ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   do we have constants for maxRow (65536 in excel 2003) and maxColum (https://www.excelbanter.com/excel-programming/400794-do-we-have-constants-maxrow-65536-excel-2003-maxcolum.html)

Fil

do we have constants for maxRow (65536 in excel 2003) and maxColum
 


Niek Otten

do we have constants for maxRow (65536 in excel 2003) and maxColum
 
as long as there is a sheet open:

activesheet.columns.count

or even

application.columns.count


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Fil" wrote in message ...
|



Fil

do we have constants for maxRow (65536 in excel 2003) and maxC
 
thank you

"Niek Otten" wrote:

as long as there is a sheet open:

activesheet.columns.count

or even

application.columns.count


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Fil" wrote in message ...
|





All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com