Hi
With the help of people on this board, I've used this code to copy a formula to cell I4, then drag it down column I until the number of rows populated in column G.
However, I would like to drag it down to the second last row populated in column G.
Does anyone know how to do this, please?
With the help of people on this board, I've used this code to copy a formula to cell I4, then drag it down column I until the number of rows populated in column G.
However, I would like to drag it down to the second last row populated in column G.
Does anyone know how to do this, please?
VBA Code:
Range("I1").Copy
Range("I4:I" & Range("G" & Rows.Count).End(xlUp).Row).PasteSpecial xlPasteFormulas