Excel Constants for maximum number of rows, columns?

F

Frank Jones

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
 
B

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)

Frank Jones said:
Using Microsoft Office Excel 2003 COM Automation.

Are there any constants in the Excel Office 2003 COM library for maximum
Click to expand...
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
Click to expand...
values. If there are such constants, are they also there for other versions
of Excel, like Office XP, Office 2000?
 
F

Frank Jones

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 said:
Using Microsoft Office Excel 2003 COM Automation
Click to expand...
values. If there are such constants, are they also there for other version
of Excel, like Office XP, Office 2000
 
Top