software

I hide and unhide rows all the time and don't have a problem, but this time
I do with one worksheet in my workbook.

I have tried selecting a cell, or many cells in the area hidden, using the
Go To command in the Edit toolbar, and then using the Unhide feature under
Format on the toolbar without success.

I've checked that the sheet code has the EnableSelection set to
xlNoRestrictons.

I've clicked the last visable cell and dragged the mouse down whilst holding
the left mouse button down and then selecting Unhide (which is my normal
method).

I can hide more rows and then unhide them again, but from row 949 onwards
they will not unhide

Sheet is not locked! All the columns are visable.

AAAaaaarrrrggggg!!!! Any suggestions anyone?

Rob

Hooray! Found the answer.....I highlighted the whole worksheet and changed
the row height to 12 for all rows and the unhide procedure worked. A
mystery to me!!!

If someone could give a reason for this, I would certainly appreciate that.

Rob

quot;Robquot; gt; wrote in message
...
gt;I hide and unhide rows all the time and don't have a problem, but this time
gt;I do with one worksheet in my workbook.
gt;
gt; I have tried selecting a cell, or many cells in the area hidden, using the
gt; Go To command in the Edit toolbar, and then using the Unhide feature under
gt; Format on the toolbar without success.
gt;
gt; I've checked that the sheet code has the EnableSelection set to
gt; xlNoRestrictons.
gt;
gt; I've clicked the last visable cell and dragged the mouse down whilst
gt; holding the left mouse button down and then selecting Unhide (which is my
gt; normal method).
gt;
gt; I can hide more rows and then unhide them again, but from row 949 onwards
gt; they will not unhide
gt;
gt; Sheet is not locked! All the columns are visable.
gt;
gt; AAAaaaarrrrggggg!!!! Any suggestions anyone?
gt;
gt; Rob
gt;
gt;
gt;
Hi Rob,

I suspect that the rows in question were not hidden but had had their height
set to a very low value, e.g. 0.5.

At such a value the rows would not be visible but would not respond to an
unhide instruction.---
Regards,
Normanquot;Robquot; gt; wrote in message
...
gt; Hooray! Found the answer.....I highlighted the whole worksheet and changed
gt; the row height to 12 for all rows and the unhide procedure worked. A
gt; mystery to me!!!
gt;
gt; If someone could give a reason for this, I would certainly appreciate
gt; that.
gt;
gt; Rob
gt;
gt; quot;Robquot; gt; wrote in message
gt; ...
gt;gt;I hide and unhide rows all the time and don't have a problem, but this
gt;gt;time I do with one worksheet in my workbook.
gt;gt;
gt;gt; I have tried selecting a cell, or many cells in the area hidden, using
gt;gt; the Go To command in the Edit toolbar, and then using the Unhide feature
gt;gt; under Format on the toolbar without success.
gt;gt;
gt;gt; I've checked that the sheet code has the EnableSelection set to
gt;gt; xlNoRestrictons.
gt;gt;
gt;gt; I've clicked the last visable cell and dragged the mouse down whilst
gt;gt; holding the left mouse button down and then selecting Unhide (which is my
gt;gt; normal method).
gt;gt;
gt;gt; I can hide more rows and then unhide them again, but from row 949 onwards
gt;gt; they will not unhide
gt;gt;
gt;gt; Sheet is not locked! All the columns are visable.
gt;gt;
gt;gt; AAAaaaarrrrggggg!!!! Any suggestions anyone?
gt;gt;
gt;gt; Rob
gt;gt;
gt;gt;
gt;gt;
gt;
gt;
Thanks Norman. I suspected something like this, but I had not changed the
height to anything near that. The minimum I used throughout the worksheet
was 5 not .5.

Oh well, maybe just a gliche.

Rob

quot;Norman Jonesquot; gt; wrote in message
...
gt; Hi Rob,
gt;
gt; I suspect that the rows in question were not hidden but had had their
gt; height set to a very low value, e.g. 0.5.
gt;
gt; At such a value the rows would not be visible but would not respond to an
gt; unhide instruction.
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt; quot;Robquot; gt; wrote in message
gt; ...
gt;gt; Hooray! Found the answer.....I highlighted the whole worksheet and
gt;gt; changed the row height to 12 for all rows and the unhide procedure
gt;gt; worked. A mystery to me!!!
gt;gt;
gt;gt; If someone could give a reason for this, I would certainly appreciate
gt;gt; that.
gt;gt;
gt;gt; Rob
gt;gt;
gt;gt; quot;Robquot; gt; wrote in message
gt;gt; ...
gt;gt;gt;I hide and unhide rows all the time and don't have a problem, but this
gt;gt;gt;time I do with one worksheet in my workbook.
gt;gt;gt;
gt;gt;gt; I have tried selecting a cell, or many cells in the area hidden, using
gt;gt;gt; the Go To command in the Edit toolbar, and then using the Unhide feature
gt;gt;gt; under Format on the toolbar without success.
gt;gt;gt;
gt;gt;gt; I've checked that the sheet code has the EnableSelection set to
gt;gt;gt; xlNoRestrictons.
gt;gt;gt;
gt;gt;gt; I've clicked the last visable cell and dragged the mouse down whilst
gt;gt;gt; holding the left mouse button down and then selecting Unhide (which is
gt;gt;gt; my normal method).
gt;gt;gt;
gt;gt;gt; I can hide more rows and then unhide them again, but from row 949
gt;gt;gt; onwards they will not unhide
gt;gt;gt;
gt;gt;gt; Sheet is not locked! All the columns are visable.
gt;gt;gt;
gt;gt;gt; AAAaaaarrrrggggg!!!! Any suggestions anyone?
gt;gt;gt;
gt;gt;gt; Rob
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;