Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets vs worksheet
Is there a difference with sheets(1) and worksheets(1)?
Will Name = worksheets(1) (or sheet(1)) give me the name assigned to the worksheet? Is the order of the worksheets the same as the displayed order when the workbook is open? Want to activate and work on first 16 worksheets which plop values into the last two worksheets. I'm using: For n = 1 to 16 Sheets(n).select rada, rada, rada Next It doesn't seem to be working thanks John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
40 sheets/Formula to advance to next worksheet | Excel Worksheet Functions | |||
Splitting a Worksheet into Multiple Sheets | Excel Worksheet Functions | |||
How do I access the other sheets in my Excel worksheet | Excel Discussion (Misc queries) | |||
Naming Sheets using a range in another worksheet | Excel Worksheet Functions | |||
Copy info from worksheet 1 to other sheets | Excel Worksheet Functions |