sum funtion not working in VBA

Good Morning,
I would appreciate some help with troubleshooting my formula in vba

I am trying to sum a range of cells as follows:

lastYrOSHA = Application.WorksheetFunction.Sum(Cells(39, 10), Cells(eRow, 10))

where eRow is the last row which is calculated using another formula (erow = 32 currently)

the sum formula is returning a value of 1 and it should be 8

If I use the exact cell reference in a select Range formula it selects the range fine

Range(Cells(39, 10), Cells(eRow, 10)).Select

Why is it returning a value of 1 when the sum of these cells is 8

Thank you,

Mike

Richard,

The sum of this range should be 8, but I am only returning a 1

Mike

Xero,

sorry if this post twice, but I did not see it the first time (newby).

My cellse look as follows:
J32=1
J33=2
J34 =0
J35=0
J36 = 3
J37 =2
J38 =0
J39 =0

A numbers in this range are formated to be numbers with no decimal points.

Mike

Yudlugar,

You are correct, I just change J32 to be a 5 and my formula returened a sum of 5, hmmm.... Does this mean that my range in this sum formula is only looking at J32?? That is confusing as when I use it in a range formual it selects the entire range.

Thanks for the catch,

Mike

Thank you all, Xero solved the problem. I can take deep breath now