Excel formula in VBA

bgkgmg · Sep 25, 2008

How would I enter the Excel fromula SUM(A1,A3) into a macro. I am getting
confused on the different methods ie, R1C1 etc.

Thanks

Mike H · Sep 25, 2008

Maybe

myvalue = WorksheetFunction.Sum(Range("a1:a3"))

Mike

Gary Keramidas · Sep 25, 2008

maybe this?
range("C3").Formula = "=sum(A1,A3)"