H
Howard Kaikow
Are there built-in Excel constants for maximum number of rows, for columns?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Built-in Excel constant for maximum number of rows, for columns?
P
Peter T
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
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
B
Bob Phillips
Yes, Rows.Count and Columns.Count
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
J
JE McGimpsey
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.
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.
H
Howard Kaikow
Ayup, I should have said "property", instead of "constant".