Used Range Problem
 

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
--

Used Range Problem
 

SAVE
if that doesn't work
exit

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Donald Lloyd" wrote in message
...
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
--

Used Range Problem
 

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

Used Range Problem
 

Thanks Don

I've done both.
Don

--

"Don Guillett" wrote in message
...
SAVE
if that doesn't work
exit

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Donald Lloyd" wrote in message
...
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
--

Used Range Problem
 

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 wrote in message
...
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 Ogilvy" wrote in message
...
In a single sheet new workbook,
I filled A1:AZ69 with Data. I selected BA:CZ and did
format=Cells=Protection Tab, and unchecked locked.

I saved the file. It is about 37KB. I did an edit=goto =special
and
selected last cell. It went to CZ69.


(A:H was also unlocked from an initial test).


Have you changed the row height? done other things?

xl97, SR2 US English, Win 98 SE

Regards,
Tom Ogilvy


Donald Lloyd wrote in message
...
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
--

Used Range Problem
 

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
--

"Tom Ogilvy" wrote in message
...
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

Used Range Problem
 

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"
wrote in message ...< 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.