Deleting lines really deletes lines!

  • Thread starter Thread starter EmmanuelleZ
  • Start date Start date
E

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
 
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.
 
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
 
Back
Top