Excel 2007 : Need a Non Volatile Replacement For INDIRECT

[boohah]

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

[DonkeyOte]

use INDEX

=INDEX(A:A,B5)

[boohah]

Hi Donkey

Mate... that was simple and very effective. This isnt the first time you have helped me out and every time you have you have been right on the money. Thanks Heaps.

Doug