Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Getting & Using Sheet Names or Index in VBA code
How do you get each Sheet Name in a Workbook so you can use it in code? I
know that each Sheet, regardless of Name has an Index of 1 through n beginning with the leftmost Sheet but I don't know how to use that information. I have one reference book, Excel 2003 VBA, that says there is a Worksheet Property 'Name' that returns a String and in the Description of that Property it says 'Set/Get the name of the worksheet'. Unfortunately, it doesn't tell me how to use that in code. I don't really care whether I use the name of each Sheet or the Index but if you can use either it would be nice to know both ways. I know a way to write the code if I know the Sheet names but I want the code to be more flexible so I don't have to 'hard code' them. Thanks rw |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell names = sheet names | Excel Worksheet Functions | |||
Sheet names code | Excel Discussion (Misc queries) | |||
VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
Creating and Index with worksheet names | Excel Discussion (Misc queries) | |||
I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions |