macro to copy formula to end of range

[nods]

Hi I have a worksheet with formula in F2 and G2. Column H is populated by data captured in a user form.

I would like to program the form to copy the the formula down to the the last row in the range.

For example if the user enters data and column H is then filled upto row 12 (this could be different every time) then I want the formula to copy down to row 12 in columns F and G!

I hope that makes sense.Can anybody help?

This is the code I have so far but it copys all the way down to the bottom of the work book,

Many thanks

Please Login or Register  to view this content.

[jaslake]

Hi nods

It'll probably be something like this

Please Login or Register  to view this content.

John

[royUK]

Does the userform enter one entry at a time?