![]() |
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. |
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