=INDIRECT($A$3&"!B"&ROW(B53))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Eden397" wrote in message
...
=INDIRECT($A$3&"!B53")
I want to autofill down my column but have the B53 change to B54, B55,
etc.
How do I set that up. I think it has something to do with "rows"?
Thanks,
Eden 397