VBA- Insert formula up to last row

[Johnatha]

Hi,

I'm looking to insert a formula onto a sheet using a macro. So far my code works and looks like this

Please Login or Register  to view this content.

The problem is that it inserts the formula for the entire column D. I'd like to have the formula start from cell "D1" and finish wherever my last cell in column C is located (for example, "C75" so range "D1:D75").

Is there any way I can do this? I sort of know how to use LastRow but not sure how to apply it here. Still a newbie

Thanks!
Johnathan

[Jakobshavn]

Consider:

Please Login or Register  to view this content.

[Johnatha]

@Jakobshavn WOW that's perfect! Works great.

Thank you so much my friend.