[VBA] Insert a formula into a cell from within VBA

[dylanrose]

Hi friends,

Basically, I have the majority of my code worked out with previous help from the wonderful people here. But I am getting stuck with getting a formula into a cell from within VBA.

If the formula were viewed from cell AF3 in the worksheet it would appear as:

Please Login or Register  to view this content.

This formula is repeated several times throughout the worksheet in just the column AF from AF3 down to the last column used.

Could you help me with this one guys?

Thanks and God bless!

[Trebor76]

Hi dylanrose,

Try this:

Please Login or Register  to view this content.

HTH

Robert

[dylanrose]

Hi dylanrose,

Try this:

Please Login or Register  to view this content.

HTH

Robert

Woah that's fast!

May I ask if this is possible too if I put this code in

Please Login or Register  to view this content.

so that it'll automatically fill in the said column?

I'll try it now and I'll reply as fast as possible.
Thanks so much Trebor76!