| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error in cell function
I am trying to use the cell function to create a dynamic hyper link to
several sheets. i can use: =HYPERLINK("#"&CELL("address",'Mall1 1-7'!A3),A2) but i need to do a whole bunch and the sheet names change frequently so i try: =HYPERLINK("#"&CELL("address","'"&Intro!A3&" 1-7'"!A3),A2) I keep getting error messeges. Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELL Function: cell reference by formula | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Can function in one cell change value or function in another cell? | Excel Worksheet Functions | |||
| Function that Returns address of that cell? | Excel Worksheet Functions | |||
| Reading Cell Function??? | Excel Worksheet Functions | |||
Threaded Mode
