Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |