| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet vs. Worksheets
What's the difference? When do I use Worksheet? When do I use Worksheets?
The reason I'm asking is that I'm trying to find the value in cell A1 of the first sheet of a workbook. This sheet may appear by different names. I've successfully called this sheet before using ActiveWorkbook.Worksheets("Sheet1").Range("A1").va lue. This time, I'm getting a "Subscript out of Range" error. Yeah - I wanna be a Geico Caveman... -- Adios, Clay Harryman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I split the worksheet in two different worksheets | New Users to Excel | |||
| Copy worksheets to new worksheet and add a worksheet name column to new sheet. | Excel Programming | |||
| Name of worksheets in one worksheet | Excel Worksheet Functions | |||
| Consolidate different worksheets into one worksheet | Excel Discussion (Misc queries) | |||
| One worksheet into two worksheets | Excel Programming | |||
Threaded Mode
