Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Built-in Excel constant for maximum number of rows, for columns?
Are there built-in Excel constants for maximum number of rows, for columns?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Built-in Excel constant for maximum number of rows, for columns?
AFAIK no and don't see how a constant would be viable. The number of rows &
columns in a sheet is version dependant. Although versions 8-11 have 65536 x 256, earlier versions have less and I understand XL12 will have considerably more. nRows = ActiveSheet.Rows.Count nCols = ActiveSheet.Columns.Count Regards, Peter T "Howard Kaikow" wrote in message ... Are there built-in Excel constants for maximum number of rows, for columns? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Built-in Excel constant for maximum number of rows, for columns?
Yes, Rows.Count and Columns.Count
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Howard Kaikow" wrote in message ... Are there built-in Excel constants for maximum number of rows, for columns? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Built-in Excel constant for maximum number of rows, for columns?
Note that these really aren't' constants, but are properties of the Rows
and Columns collection (which are child objects of Worksheet - not qualifying them defaults to the ActiveSHeet). Since the number of rows in a worksheet is version dependent, using this method is superior to constants, since Rows.Count will return the number of rows in the activesheet for XL4 (16757), and XL97-04 (65536) and will return over 1,000,000 for XL12. In article , "Bob Phillips" wrote: Yes, Rows.Count and Columns.Count -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Howard Kaikow" wrote in message ... Are there built-in Excel constants for maximum number of rows, for columns? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Built-in Excel constant for maximum number of rows, for columns?
Ayup, I should have said "property", instead of "constant".
-- http://www.standards.com/; See Howard Kaikow's web site. "JE McGimpsey" wrote in message ... Note that these really aren't' constants, but are properties of the Rows and Columns collection (which are child objects of Worksheet - not qualifying them defaults to the ActiveSHeet). Since the number of rows in a worksheet is version dependent, using this method is superior to constants, since Rows.Count will return the number of rows in the activesheet for XL4 (16757), and XL97-04 (65536) and will return over 1,000,000 for XL12. In article , "Bob Phillips" wrote: Yes, Rows.Count and Columns.Count -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Howard Kaikow" wrote in message ... Are there built-in Excel constants for maximum number of rows, for columns? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DOES EXCEL HAVE a MAXIMUM NUMBER OF COLUMNS PER WORKBOOK? | Excel Discussion (Misc queries) | |||
what is the maximum number of rows excel for mac 2008? | Excel Discussion (Misc queries) | |||
what is the maximum number of rows excel for mac 2008 has? | Excel Discussion (Misc queries) | |||
maximum number of rows in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel Constants for maximum number of rows, columns? | Excel Programming |