Excel Constants for maximum number of rows, columns?
HI Frank,
Not a constant as such, but a property of the respective objects, that is
Rows.Count
and
Columns.Count
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Frank Jones" wrote in message
...
Using Microsoft Office Excel 2003 COM Automation.
Are there any constants in the Excel Office 2003 COM library for maximum
number of rows (65,536) and maximum number of columns (256) on a Worksheet?
Looked through the library and could not find any constants for those
values. If there are such constants, are they also there for other versions
of Excel, like Office XP, Office 2000?
Thanks,
Frank
|