Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't have XL2007 yet, but I've been thinking about how I might need
to rewrite code to cope with the new worksheet grid size. Since XL2007 has 2^20 rows and 2^16 columns, it has 2^36 cells per worksheet. That's more than can be stored in a long integer (which can store only up to 2^31-1). Has the return type for the .Count property of the Range class become Double type, or will .Count property calls for ranges with more than 2^31-1 cells throw errors or (this'd be fun!) return incorrect long integer values, e.g., returning unsigned longs from the underlying Excel OM implementation that would be interpreted as negative signed integers by VBA? I did search Google Groups, but I found nothing on this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Count Values in Pivot Table (Excel 2007) | Excel Discussion (Misc queries) | |||
Want to count all repeated number only once in Excel 2007. | Excel Worksheet Functions | |||
Count rows that meet 2 conditions in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 formula to count color changes in a cell | Excel Worksheet Functions | |||
Excel 2007 - Pivottable formula with COUNT | Excel Worksheet Functions |