Thanks! The indirect function works perfectly!

"Mallycat" wrote:


Maybe you could use the indirect() function. You can then build an
address by combining data in different cells. ie

in column A, enter 1, 2, 3 etc down the column
in B1, enter "=7-7-"&A1&"!$O$45"
in C1 enter indirect (B1)

copy the whole lot down the columns and it should give you what you
want.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561246