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

ActiveCell.Formula = ActiveCell.Offset(formA, 0) + ActiveCell.Offset(formB, 0)
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