I would like to copy some formula using variable which contain row number (the most to fill in)
I did something like this:
ActiveCell.FormulaR1C1 = "=RC[-1]/RC[-2]"
Selection.AutoFill Destination:=Range("A1:A" & Range("NrR").Value)
In NrR (integer) I store say no. 10
And now using auto fill I would like to copy formula 10 rows down. How to change my macro code?