| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets(2) = 2nd tab? = Sheet2 (Sheet2)?
Set rngA = Sheets(2).Range("A:A")
Does Sheets(2) mean the 2nd tab from the left? In VBE, under Microsoft Excel Objects, the 2nd tab appears as: Sheet2 (Sheet2) What is the first instance of Sheet2 in the above ? I gather that the 2nd instance -- within parens -- is the tabname, which can be changed by user. How could use be made of the 1st instance which apparently cannot be changed and is more robust? An example line or 2 illustrating this usage would be welcomed. Thanks. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| macro to print sheet2 without open sheet2 | Excel Discussion (Misc queries) | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| Go to sheet2 | Excel Programming | |||
| first name and a second name - In Sheet2 I only need the first name | Excel Programming | |||
Threaded Mode
