| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Did evalution of empty cells change in Excel 2007?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cells from starting Right to Left Excel 2007 | Setting up and Configuration of Excel | |||
| fill down empty cells at every change in value | Excel Worksheet Functions | |||
| Evalution of a cell-entry | Excel Worksheet Functions | |||
| How to change the color of selected cells in excel 2007 | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
Threaded Mode
