Hi
I am running a large spreadsheet that is slowing as I add more data. The problem is an INDIRECT function present in about 20 columns of calculation and I need to replace it. Does anybody know a non volatile way of writing the following formula:
=INDIRECT("A"&B5)
Any help would be appreciated.
Doug
Bookmarks