View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
emm[_2_] emm[_2_] is offline
external usenet poster
 
Posts: 1
Default 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



.