| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL VBA non-volatile INDIRECT
So after you have entered all your data enter the last row number in a cell
and refer to that. Charles ______________________ Decision Models FastExcel Version 2 now available. www.DecisionModels.com/FxlV2WhatsNew.htm "aareding " wrote in message ... For my purposes, INDIRECT doesn't need to be volatile. I enter all of my data at the start of the day and it needs to calculate once and then be used in all of my database formulas. --- 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 | |||
Threaded Mode
