It behaves identically for me.

The right-hand side does return null in both cases, but setting a long to
that value returns 0 in each case.

--
__________________________________
HTH

Bob

"Gustaf" wrote in message
...
From trying my VBA app in both Excel 2003 and 2007, I came to the
conclusion that 2007 seem to handle empty cells differently. The code
looks something like this:

lngVolume = wsMySheet.Cells(iRow, iCell)

lngVolume is a Long. In Excel 2003, the right hand expression returns "",
while in Excel 2007, it returns 0. Can anyone confirm this?

Gustaf