Excel Constants for maximum number of rows, columns?
 

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

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

Excel Constants for maximum number of rows, columns?
 

Thanks Bob

----- Bob Phillips wrote: ----

HI Frank

Not a constant as such, but a property of the respective objects, that i

Rows.Coun

an

Columns.Coun

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

"Frank Jones" wrote in messag
..
Using Microsoft Office Excel 2003 COM Automation
Are there any constants in the Excel Office 2003 COM library for maximu
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 thos
values. If there are such constants, are they also there for other version
of Excel, like Office XP, Office 2000
Thanks
Fran