| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect reference and worksheets with single quote in the name
I can't seem to use the indirect function to lookup data in another sheet if
the sheet name contains a single quote. Sheet1 - I have in cell A1: Sheet2!A1 In cell A2 I have: =INDIRECT(A1) If I change the name of Sheet2 to Int'l and change the contents of A1 to Int'l!A1 then it no longer works. What can you do when the sheet name has a single quote? I am going to be referencing data from a web site and I want the names of the sheets to be able to be referenced just by the name of the data. I have no control over this data and so it will have the ' in it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and using single quote | Excel Worksheet Functions | |||
| Single Quote use in cell reference | Excel Worksheet Functions | |||
| Remove single quote | Excel Worksheet Functions | |||
| indirect cell reference using copies of worksheets in same workboo | Excel Worksheet Functions | |||
| Summarizing Data across Worksheets using a single reference | Excel Worksheet Functions | |||
Threaded Mode
