开发者

how to insert formula in excel using vba

How to insert the formula for th开发者_运维知识库e entire column using vba


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)"
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜