| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
| Maximum Rows in Excel... | Excel Discussion (Misc queries) | |||
| Excel should have 200,000 rows maximum | Setting up and Configuration of Excel | |||
| What is the maximum number of rows in an Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
| Maximum no of rows in Excel | Excel Worksheet Functions | |||
Linear Mode
