How to insert the formula for the entire column using vba
+1
A:
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)"
Cornelius
2010-06-01 07:56:01
Thank you so much for your answer but i am facing another problem ,In my sheet i am insert the formula in the cell at the range G5 from G5 onwards i want to auto fill the formula in the entire column it is possible ?
raam
2010-06-01 09:50:33
you could use range("G5:G65536").formula = ...
Cornelius
2010-06-01 10:40:00