ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting lines really deletes lines! (https://www.excelbanter.com/excel-programming/278271-re-deleting-lines-really-deletes-lines.html)

Jim[_28_]

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




emm[_2_]

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