Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUM in VBA
In the worksheet:
=SUM(Sheet1!A1:Sheet1!A13) works just fine, giving the sum of cells. In VBA: Dim i As Variant i = Application.SUM(Sheet1!A1:Sheet1!A13) just give a compile error. Why? -- Gary's Student |