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?
|