Used Range Problem

  • Thread starter Thread starter Donald Lloyd
  • Start date Start date
D

Donald Lloyd

Hi,

On a worksheet I am using the first 69 rows and the first 55 columns.
Everything was fine until I unlocked a range of 31 columns.

Following guidelines from the group a couple of days ago, I unlocked the
entire columns.
This resulted in the file size increasing from 240 kb to 1.57 mb, with the
used range covering the entire worksheet. (The sheet referred to is a
template and a further 11 copies are to be added - I hate to think about the
resultant file size!)

I have cleared and deleted then unused columns which changed the used range
to cover the used columns, although this has not reduced the file size.

I have also in desperation cleared and deleted the unused rows below my
usage, but this has not
made any difference - the used range still covers the entire column range.

Any ideas will be gratefully considered.

Regards,
Don
--
 
Hi,

Further to my original post I have since repeated the operation of clearing
and deleting the rows below my usage and this resulted in these rows
disppearing entirely (as if hidden) and I can't make them reappear. The file
size however has dropped to 180 kb.

HELP!

regards,
Don
 
Just to copy everything to a new workbook.

I have never had rows less than 65536 unless I had them hidden.

Something sounds hosed up.

Did you click at the intersection of the row and column labels, then do

Format=>Row=>Unhide

and also

Format=>row=>Height enter 12.75 and OK


or in the immediate window

Rows("1:65536").Hidden = False

rows("1:65536").rowHeight = 12.75

--
Regards,
Tom Ogilvy



Donald Lloyd said:
Hi Tom,

Thank you for the prompt response.
My workbook size is greater because there is a lot of detailed formatting, a
fair number of objects and a lot of code.
No, I've changed nothing else. I now seem to be stuck with a sheet that has
69 rows.
Nothing I've tried will make them reappear - Cells.Rows.Hidden=false etc.
There is another sheet in th workbook but this is entirely normal.
Could it be that I have a corrupt sheet ?

If so, is there a solution ?

xl97, Sr2, UKEnglish, Win 98 (SE I think)

Don

--
 
Tom

If you've seen my latest post you will note that things now seem to be O.K.

As a matter of interest, your suggestion to size all row heights worked on
the "rogue" file.

Thanks again,
Don
 
Hi Don,
Some additional things that are more obvious than Tom's list, as
I had not even thought about hidden cells, though I see you also
mentioned that you don't have them.
..
Any of these should show you more rows
- type A65536 into the name box at the left of the formula bar.
- select a cell at the bottom of what you see and drag downward
to select more cells.
- click on the vertical scrollbar navigation arrow below the vertical scroll bar.

Do you see the vertical scrollbar, if not see Tools, Options, View

If you have the sheet protected (Data, ...) you may not be able to change
options.

ScrollArea can be restricted in code, to eliminate in code, along the lines ofi
Worksheets(1).ScrollArea = ""
HTH,David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htmSearch Page: http://www.mvps.org/dmcritchie/excel/search.htm"Donald Lloyd"
sheet that has> 69 rows.> Nothing I've tried will make them reappear - Cells.Rows.Hidden=false etc.
 
Back
Top