Are there built-in Excel constants for maximum number of rows, for columns?
Are there built-in Excel constants for maximum number of rows, for columns?
AFAIK no and don't see how a constant would be viable. The number of rows &
columns in a sheet is version dependant. Although versions 8-11 have 65536 x
256, earlier versions have less and I understand XL12 will have considerably
more.
nRows = ActiveSheet.Rows.Count
nCols = ActiveSheet.Columns.Count
Regards,
Peter T
"Howard Kaikow" <[email protected]> wrote in message
news:[email protected]...
> Are there built-in Excel constants for maximum number of rows, for
columns?
>
>
Yes, Rows.Count and Columns.Count
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Howard Kaikow" <[email protected]> wrote in message
news:[email protected]...
> Are there built-in Excel constants for maximum number of rows, for
columns?
>
>
Note that these really aren't' constants, but are properties of the Rows
and Columns collection (which are child objects of Worksheet - not
qualifying them defaults to the ActiveSHeet).
Since the number of rows in a worksheet is version dependent, using this
method is superior to constants, since Rows.Count will return the number
of rows in the activesheet for XL4 (16757), and XL97-04 (65536) and will
return over 1,000,000 for XL12.
In article <[email protected]>,
"Bob Phillips" <[email protected]> wrote:
> Yes, Rows.Count and Columns.Count
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Howard Kaikow" <[email protected]> wrote in message
> news:[email protected]...
> > Are there built-in Excel constants for maximum number of rows, for
> columns?
> >
Ayup, I should have said "property", instead of "constant".
--
http://www.standards.com/; See Howard Kaikow's web site.
"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> Note that these really aren't' constants, but are properties of the Rows
> and Columns collection (which are child objects of Worksheet - not
> qualifying them defaults to the ActiveSHeet).
>
> Since the number of rows in a worksheet is version dependent, using this
> method is superior to constants, since Rows.Count will return the number
> of rows in the activesheet for XL4 (16757), and XL97-04 (65536) and will
> return over 1,000,000 for XL12.
>
> In article <[email protected]>,
> "Bob Phillips" <[email protected]> wrote:
>
> > Yes, Rows.Count and Columns.Count
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Howard Kaikow" <[email protected]> wrote in message
> > news:[email protected]...
> > > Are there built-in Excel constants for maximum number of rows, for
> > columns?
> > >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks