Thread: Indirect function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eden397 Eden397 is offline
external usenet poster
  
Posts: 40
Default Indirect function
=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
Reply With QuoteReply With Quote