How to drag formula down to second last row in column A?

[Mr2017]

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?

Range("I1").Copy
Range("I4:I" & Range("G" & Rows.Count).End(xlUp).Row).PasteSpecial xlPasteFormulas

 

[Fluff]

How about

Range("I4:I" & Range("G" & Rows.Count).End(xlUp).Offset(-1).Row).PasteSpecial xlPasteFormulas

 

[Mr2017]

Excellent!

Thanks Fluff - that worked!!

Thank you!

 

[Fluff]

My pleasure