Excel Constants for maximum number of rows, columns?

[Guest]

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

 

[Bob Phillips]

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)

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?

 

[Guest]

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

Using Microsoft Office Excel 2003 COM Automation

values. If there are such constants, are they also there for other version
of Excel, like Office XP, Office 2000