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/