Dynamic formula in cell with vba

[twinpowr]

Hi,

I have just read a post in which it describes how to put a formula in a cell with vba. Which works great, but how do we make that formula dynamic and follow on from the previous cell example:-

=IF(A2="","",IF(F2<>"",A2+0,A2+7))

so when im entering data from a userform and moving down through the rows, then next row should then be

=IF(A3="","",IF(F3<>"",A3+0,A3+7))

and onwards down the rows.

Thanks in advance for any help

Ally.

 

[twinpowr]

ok got it working.

me being stupid.

thanks for your help Glenn, got there in the end, the code above is fine. i copied and pasted it wrong. think i will go to bed and start again.

Thanks

Ally.

 

[GlennUK]

Ha ha, sounds like a tough day. Glad you got it working.