Entering formulas using activecell.offset

Hi,
This should be pretty simple but for the life of me I can't figure it out!

I have manipulated data from a database and now have to add many formulas throughout the new worksheet.

I can get the correct value using

Please Login or Register  to view this content.

This would enter the correct value however I would then have to repeat this step throughout the spreadsheet where required. (In total this is nearly 5000 times)

If however I could enter it as a formula (where formA=3, formB=36 the cell value = F3+F36)
I can then copy paste that across range(s) and it would speed up the macro greatly.

So how do I enter a formula using variables formA & formb?

Many thanks

Hi

Like this:

Please Login or Register  to view this content.

Richard

Many Thanks Richard,

It's not exactly what I wanted (I think my explanation was a bit misleading) but you pointed me in the right direction

Please Login or Register  to view this content.

Cheers