Using Excel Formula in VBA

[anandmr65]

Hi,

Can we use the excel formula in VBA directly without putting them on to worksheet.

FOr example a formula to sum a range like =SUM(A1:A10). As of now I am putting this to a dummy cell through VBA code, then getting value back again from that.

Now the question is : Can we use this SUM(A1:A10) formula directly in the code and get the value without pasting this formula to excel worksheet and get the summed value from that cell. Is there any method to achieve this.

Please help. Thanks a lot in advance for the expert advice.

Regards
Anand

[rylo]

Hi

A couple of ways I can think of

MsgBox WorksheetFunction.Sum(Range("A1:A3"))

or

MsgBox Evaluate("=sum(a1:a3)")

rylo

[anandmr65]

Hi Rylo,

Thanks a lot for quick reply.

Regards
Anand