correctly formula in vba

[Forestq]

Hi,


I have formula:

ws_22.Range("N73:N" & row_to_del).Formula = "=SUM(I73:M73)"

How to add "row_to_del" to function SUM?

ws_22.Range("I100:M100").Formula = "=SUM(I73:I & row_to_del)" 'its wrong

I tried also

"=SUM(I73:I """& row_to_del""")"

but also is wrong.

 

[vds1]

Try,

ws_22.Range("I100:M100").Formula = "=SUM(I73:I" & row_to_del & ")"

 

[Forestq]

thank you VDS1!