What are you trying to do that you need to exceed 65,536 rows?
thank you for a good approach to the question.the answer is:
I need it for nothing,but the problem is of the different kind.
My job in the the firm where i work in, is to write procedure and macros for the controlling departments in VBA (not only).Despite of many examples of how vba have helped them in their work i still hear voices like this "excel is good but it has the limitation.you cannot exceed the number of rows over 60....rows". i heard that so many time that i had to check this out.
im sorry for engaging your time and thank you for the answer
Not a problem. A little trivia for them if they want to see how much each worksheet in Excel holds. Have them put a number into one cell, then another number into the next cell. Then do it for the entire worksheet (16,777,216 cells). And fill in a cell at the rate of one cell per second, continuous, no breaks. It will take the person 194 days, and to print just that one worksheet it would take 6 ft of paper.
And the number of worksheets available in a workbook is limited only by the memory of your PC.
old, slow, and confused
but at least I'm inconsistent!
i was really laughing having been reading your post but...
seriously your hints were a very instructive lessons for me.
bye the way. with regard to the people from my company i thought to myself that they deserved to see only nothing.let them lead a live of ignorance