Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.programming
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



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting lines that use them for formulas OX_Gambit Excel Discussion (Misc queries) 4 April 2nd 09 01:30 PM
Deleting unused lines between used lines? Stevel Setting up and Configuration of Excel 1 November 25th 05 12:58 AM
Deleting Lines in Excel sibadee14 Excel Discussion (Misc queries) 1 November 16th 05 06:56 AM
Deleting multiple lines tammytlc Excel Discussion (Misc queries) 1 October 3rd 05 11:49 PM
Deleting duplicate lines Tom Ogilvy Excel Programming 0 September 18th 03 04:27 PM


All times are GMT +1. The time now is 08:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"