Chris Davison
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 1,790
Evening all,
I know =NOW and =TODAY are termed volatile and I read recently that =ROW and =COLUMN are to a certain extent
is =INDIRECT also volatile ?
I recently posted an =INDIRECT with two =ROW functions solution which was copied to nearly 4000 rows but when I hit F9, it still just took a milli-second to calculate
I've been using INDIRECT a lot, and hadn't thought if it might affect performance....
thanks
Chris
I know =NOW and =TODAY are termed volatile and I read recently that =ROW and =COLUMN are to a certain extent
is =INDIRECT also volatile ?
I recently posted an =INDIRECT with two =ROW functions solution which was copied to nearly 4000 rows but when I hit F9, it still just took a milli-second to calculate
I've been using INDIRECT a lot, and hadn't thought if it might affect performance....
thanks
Chris