Maximum Rows inan Excel Spreadsheet

R

Ralph.Hill

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Circular reference, Maximum number of formulas 1
How to determine the length of a .prn file. 5
Excel gone out of memory 4
VBA CreateNames (ignores last 5 rows?) 6
Import extrenal data exceeds 65536 14
Delete summary rows programmatically 3
Excel trim function maybe? 1
Macro To Import Text File 3

Top