| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
INDIRECT worksheet with a space in the name
I am using the following to reference worksheets which works fine except for
when the worksheet name contains a space. =INDIRECT($A8&"!AI$8") I dont want to remove the space from the worksheet name because it will cause all other sorts of issues. How can I get this to work? Im guess it involves enclosing the the W/S in ' ' but I've had no sucess Bruce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
| Using Indirect & Creating a worksheet Macro | Excel Worksheet Functions | |||
Threaded Mode
