C-Accounts is the value contained in the cell. I thought that it might
be possible to treat a range as a associate array and use the cell
values to access certain cells in the range.

The reason I want to select the cell containing 'C-ACCOUNTS' is because
I want to get a value in a cell that is 15 rows below.

The range is in workbook wkBk, and the Worksheets is "All Data
Unnarr".

i'm not even sure this is possible, I can always use a loop, but I
thought this way would be tidier.

Cheers,

Tom


--
Tomski
------------------------------------------------------------------------
Tomski's Profile: http://www.excelforum.com/member.php...o&userid=26824
View this thread: http://www.excelforum.com/showthread...hreadid=500720