Putting formulas into vba

**Tgbell** · 07-09-2019, 09:28 AM

Hello, I have the current (below formulas) and I need to put them in VBA filling them down to the last cell.

Please Login or Register  to view this content.

How would I put the ABOVE formulas into code

then for fill down,
I was thinking of using

Please Login or Register  to view this content.

or
should i use:

Please Login or Register  to view this content.

**Fluff13** · 07-09-2019, 09:32 AM

If the formulae are already in row 3, I would use

Please Login or Register  to view this content.

**Tgbell** · 07-09-2019, 10:44 AM

what about for inserting in the formulas?

**Fluff13** · 07-09-2019, 10:55 AM

Like

Please Login or Register  to view this content.

Just remember to double-up the quotes inside the formula

Re: Putting formulas into vba