LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,231
Default Range .Count in Excel 2007

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Count Values in Pivot Table (Excel 2007) Wil Excel Discussion (Misc queries) 1 December 29th 09 10:40 PM
Want to count all repeated number only once in Excel 2007. sierra spiegel Excel Worksheet Functions 2 October 21st 09 04:33 PM
Count rows that meet 2 conditions in Excel 2007 Jason Stearns Excel Worksheet Functions 4 October 1st 09 12:21 AM
Excel 2007 formula to count color changes in a cell astrossmart Excel Worksheet Functions 1 December 2nd 08 04:54 PM
Excel 2007 - Pivottable formula with COUNT peter Excel Worksheet Functions 2 October 19th 07 10:00 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"