Deleting lines really deletes lines!

[EmmanuelleZ]

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

 

[Jim]

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.

 

[emm]

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