Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting lines that use them for formulas | Excel Discussion (Misc queries) | |||
Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
Deleting multiple lines | Excel Discussion (Misc queries) | |||
Deleting duplicate lines | Excel Programming |