I'm Sorry, I mean in the formula that you posted originally

=INDIRECT("'worksheet name'!A" & COLUMN())

What would I put in the parenthesis after COLUMN? so that it would
count the correct number or columns?


--
tpsstudent
------------------------------------------------------------------------
tpsstudent's Profile: http://www.excelforum.com/member.php...o&userid=36256
View this thread: http://www.excelforum.com/showthread...hreadid=560501