View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Indirect function

=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