CODEWITHSUNDEEP
excel
raam
raam

Reputation: 41

how to insert formula in excel using vba

How to insert the formula for the entire column using vba

Upvotes: 1

Views: 29202

Answers (1)

Marek
Marek

Reputation: 707

like this?

this is for relative notation RC

Columns("N:N").FormulaR1C1 = "=SUM(RC[1],RC[2])"

Edit:

you could also use this notation (absolute) :

Columns("M:M").Formula = "=SUM(B2:B3)"

Upvotes: 6

Related Questions