Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. flashb

    Lotus notes calendar access view

    I believe that it's possible to see who has been accessing my lotus notes calendar. Any ideas?
  2. flashb

    Auto-resize of merged cells

    why not try a simple macro one entry is complete which autofits the data in column B of sheet 3; Columns("B:B").EntireColumn.AutoFit AshB
  3. flashb

    Deleting Duplicate rows in excel

    quickest way I know without using VBA would be to do the following with a set of figures in column A: 1. sort them (so the duplicates are next to each other) 2. use some formula in a spare column such as =if(a2=a1,"*",0)in row 2 =if(a3=a2,"*",0)in row 3 and copy down to...
  4. flashb

    refering to another closed workbook

    thinking about a simple solution, you could open the spreadsheet in the VB macro and then close it once you have picked the information you are refering to. Eg. Workbooks.Open Filename:="C:\Johny\test.xls Sheets("Sheet1").Select Range("D1").Select and then do what...
  5. flashb

    refering to another closed workbook

    Perhaps I am misinterpreting your query to be too simplistic? ='C:\Johny\[test.xls]Sheet1'!$D$1 AshB
  6. flashb

    Allocating a dataset randomly to a fixed set

    Hi there, I have a set of 100 unique items, which I need to allocate randomly between 10 'names'. Each of the 10 names should be allocated an even number ie. 10. Is there a fairly simple bit of code that can do this? Any help would be appreciated. Thanks in advance AshB
  7. flashb

    Excel: hiding formula in a protected worksheet

    Thanks geoff I found an alternative - using the format - cell protection - hidden. that way i don't have to hide the formula bar for all cells. Ashb
  8. flashb

    Excel: hiding formula in a protected worksheet

    I have protected a number of cells within an excel worksheet, so that other users cannot alter the formula. I think there is a way to restrict them actually seeing the formula in these protected cells, but I can't work out how. Any help would be appreciated. Ashb

Part and Inventory Search

Back
Top