Drag down formula

Hi. In cell I50 I have a formula. I would like a macro that will drag down this formula up to the last row. (By last row I mean the last row of column H that has data)

Thanks for any help!

Record a macro manually..
Then the macro is ready...

What is the formula in I50?

BSB

Originally Posted by meus

Record a macro manually..
Then the macro is ready...

Not technically correct as a recorded macro will drag the formula down to the current last row.
If the data changes to show more or less rows in the future then the recorded macro will not perform as required.

BSB

Originally Posted by BadlySpelledBuoy

What is the formula in I50?

BSB

Thanks for your answer.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Thank you rorya! This works!