Eval Method Example

This example sets a variable to the sum of the values in the range A1:A10.

s = Spreadsheet1.ActiveSheet.Eval("=sum(a1:a10)")