Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a variable for a worksheet name?
The worksheets are in a collection called Worksheets (i think).
So access the Nth member of that collection. "Jim Cottrell" <Jim wrote in message ... Can I use a variable to access a specific worksheet? My worksheets are named 'Sheet (1)','Sheet (2)' . . . Can I constuct a formula in a cell such as "='Sheet (X)'!Price" so that if X=3 I can return the value from 'Sheet (3)'!Price ?? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Name Variable? | Excel Discussion (Misc queries) | |||
Link variable data from one worksheet to another worksheet? | New Users to Excel | |||
Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
Assigning worksheet to worksheet variable | Excel Programming |