| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL VBA non-volatile INDIRECT
I have a spreadsheet that I have been working on that involves usin
INDIRECT to get the address of the last cell in order to calculat database formulas. It was originally hardcoded and took about 1 1/ minutes to run. But I kept having to change the formulas. When changed to indirect so that I wouldn't have to keep changing formulas it now takes about 5 1/2 minutes to run. I know that everyone says no to use INDIRECT much, but I don't know another way. Has anyone writte a non-volatile INDIRECT? Or does anyone have another suggestion? I would appreciate any help! -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Avoid volatile Indirect problem | Excel Discussion (Misc queries) | |||
| why is the INDIRECT function volatile? | Excel Worksheet Functions | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
| Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN | Excel Programming | |||
![aareding[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
