ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Maximum Rows inan Excel Spreadsheet (https://www.excelbanter.com/excel-programming/313319-maximum-rows-inan-excel-spreadsheet.html)

[email protected]

Maximum Rows inan Excel Spreadsheet
 
HELP,

I have written a Macro that imports various text
files and performs many fuctions. However recently I have
found that in some cases, the files to be imported EXCEED
the Maximum Rows ALLOWED by Excel (65536).

Is there some way to increase teh number of Rows Ecel
will Import/Allow in VBA? I am using Excel 2000 (SR-1).

Your assisance in this matter will be greatly
appreciated.

Juan Pablo González

Maximum Rows inan Excel Spreadsheet
 
No, 65536 is the maximum number of rows.

--
Regards

Juan Pablo González

" wrote in
message ...
HELP,

I have written a Macro that imports various text
files and performs many fuctions. However recently I have
found that in some cases, the files to be imported EXCEED
the Maximum Rows ALLOWED by Excel (65536).

Is there some way to increase teh number of Rows Ecel
will Import/Allow in VBA? I am using Excel 2000 (SR-1).

Your assisance in this matter will be greatly
appreciated.





All times are GMT +1. The time now is 12:07 AM.

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