View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ChronicTiger
 
Posts: n/a
Default Held dragging INDIRECT FUNCTION

Im using this function.........

INDIRECT($A$2 & "!Q1")

When I drag it down a column I want the Q to increment.

If anyone can help me with this it would be much appreciated!