![]() |
Deleting lines really deletes lines!
There are ALWAYS 65,536 rows in each XL worksheet. Right-click a tab and
choose View Code to see if the rows are being hidden or the scroll area is restricted. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "EmmanuelleZ" wrote in message ... and we end up with only a few hundred lines available in a worksheet, instead of 65'536, after a few weeks of productive life. Pretty scary. Anybody experimented a workaround besides Clearing content instead of Deleting? (Excel 2002 10 2614 2625) Thanks Emm |
Deleting lines really deletes lines!
Jim
this what we believed too, and we happily used a veryhidden 'working' worksheet to copy large chunks of things, deal with them and re-insert them afterwards line by line on another worksheet with a nice format. I have Hypersnaps for you if you care emm -----Original Message----- There are ALWAYS 65,536 rows in each XL worksheet. Right- click a tab and choose View Code to see if the rows are being hidden or the scroll area is restricted. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "EmmanuelleZ" wrote in message ... and we end up with only a few hundred lines available in a worksheet, instead of 65'536, after a few weeks of productive life. Pretty scary. Anybody experimented a workaround besides Clearing content instead of Deleting? (Excel 2002 10 2614 2625) Thanks Emm . |
All times are GMT +1. The time now is 05:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com