Copy formula to second last row of sheet - VBA Macro

[james1780]

Need, a macro to copy formula to second last row of the sheet and delete the last row

Example:

I have sheet which has data on column from A to H and in Rows from 1 to 10. In column H i want to insert formula =(G2-G3)/G3 and copy this formula (as values) till Row 9 and delete Row 10

As data in sheet always changes, sometime it has 10 row, sometime 50 row, i try to record Macro, but didn't work

Any help will be highly appreciated

[jolivanes]

Will this work?

Please Login or Register  to view this content.

[james1780]

Thankyou so much, works perfectly