| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Indirect function
Hi
see the following thread for some alternatives: http://tinyurl.com/2c62u -- Regards Frank Kabel Frankfurt, Germany "Dean Phillips" schrieb im Newsbeitrag ... Hi, As the known problem with INDIRECT is that the source worksheet has to be open, has anyone got a bit of vba that will convert the cell formula to the resolved indirect formula? I have a spreadsheet that summarises several other files and the indirect formula works but I don't want to email the source files as they are too big. If the indirect formula were converted to hardcoded links I could 'break links' to convert the cells to values. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect function help | Excel Discussion (Misc queries) | |||
| Using INDIRECT Function and INDEX Function | Excel Discussion (Misc queries) | |||
| INDIRECT function inside AND function | Excel Worksheet Functions | |||
| Indirect Function and Sum | Excel Worksheet Functions | |||
| Using the Indirect.Ext function | Excel Worksheet Functions | |||
Hybrid Mode
