View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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