| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a variable for a worksheet name?
Hi
if you have placed the number in cell A1 try: =INDIRECT("'sheet (" & A1 & ")'!B1") -- Regards Frank Kabel Frankfurt, Germany Jim Cottrell wrote: 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 | |||
Linear Mode
