View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Unique713 Unique713 is offline
external usenet poster
 
Posts: 16
Default Move to next row

Is there any way to to change this macro so that every time it is run the row
is changed? Here is the macro:

Range("C1").Select
ActiveCell.FormulaR1C1 = "=Master!R[3]C"

When this is run the next time i want the 3 to be a 4. And then the next
time I want the 4 to be a 5. Is this possible?