I tried to use the SUM function in VBA. I had used similar code successfully before, but now get a zero result, even if there are non-zero numbers in the range. Here's the code. Of course, nRow, nCol and NumColsOutput have been previously defined.

Set zRange = .Range(.Cells(nRow, nCol), .Cells(nRow, NumColsOutput))
Sum = WorksheetFunction.Sum(zRange)

If I use "zRange.Select", I can see that it is selecting the desired range of cells, so the Range works correctly, yet the SUM is wrong.

I then tried the simple worksheet function, entered into a cell: =SUM(A1:D3)

I found that sometimes I got a zero result, sometimes a non-zero result.

Can anyone suggest why I might be getting these "false" zero results from the SUM function?

Thank you very much for any help you may be able to offer.

If there's always data in the range when you're using =sum
then it must be formatted as text. Are you importing data
from somewhere else? You get this kind of problem
sometimes if you're pulling data from Crystal Reports, but
I don't know about anything else.

Pete.

-----Original Message-----
I tried to use the SUM function in VBA. I had used
similar code successfully before, but now get a zero
result, even if there are non-zero numbers in the range.
Here's the code. Of course, nRow, nCol and NumColsOutput
have been previously defined.

Set zRange = .Range(.Cells(nRow, nCol), .Cells(nRow,
NumColsOutput))
Sum = WorksheetFunction.Sum(zRange)

If I use "zRange.Select", I can see that it is selecting
the desired range of cells, so the Range works correctly,
yet the SUM is wrong.

I then tried the simple worksheet function, entered into
a cell: =SUM(A1:D3)

I found that sometimes I got a zero result, sometimes a
non-zero result.

Can anyone suggest why I might be getting these "false"
zero results from the SUM function?

Thank you very much for any help you may be able to offer.

.