SUM Function Yields Zero Result

[Guest]

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(A13)

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.

 

[Pete McCosh]

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(A13)

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?