I have a number of rows in the middle of my data that are hidden and whose
height is zero. I have selected the entire sheet and issued both manual
commands (Format, Row, Unhide or autofit) and the row stays hidden. I have
done the same with vb code:

ActiveSheet.UsedRange.EntireRow.Hidden = False
ActiveSheet.UsedRange.EntireRow.AutoFit

and the rows stay hidden. The only way I have found to make a row visible
is to specifically change the row's hidden property. For example:

Rows(663).Hidden = False

Obviously I can rotate through all the rows, but that is very inefficient.
The worksheet is not protected. I can delete the rows any time I want.

Any idea why the first two commands above do not work? Using Excel 2003.

Bob

It might be due to Advance Filter... Have you tried to clear the filter?

If it does not work then try to change the row hight to a fixed value.

As a last resort, as you said, loop throught the rows and clear the hidden
setting...
"Bob Flanagan" wrote:

I have a number of rows in the middle of my data that are hidden and whose
height is zero. I have selected the entire sheet and issued both manual
commands (Format, Row, Unhide or autofit) and the row stays hidden. I have
done the same with vb code:

ActiveSheet.UsedRange.EntireRow.Hidden = False
ActiveSheet.UsedRange.EntireRow.AutoFit

and the rows stay hidden. The only way I have found to make a row visible
is to specifically change the row's hidden property. For example:

Rows(663).Hidden = False

Obviously I can rotate through all the rows, but that is very inefficient.
The worksheet is not protected. I can delete the rows any time I want.

Any idea why the first two commands above do not work? Using Excel 2003.

Bob

Many thanks. Doing Data, Filter, Show All displayed the rows. Strange....
I didn't see any filter set.

Bob

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
It might be due to Advance Filter... Have you tried to clear the filter?

If it does not work then try to change the row hight to a fixed value.

As a last resort, as you said, loop throught the rows and clear the hidden
setting...
"Bob Flanagan" wrote:

I have a number of rows in the middle of my data that are hidden and
whose
height is zero. I have selected the entire sheet and issued both manual
commands (Format, Row, Unhide or autofit) and the row stays hidden. I
have
done the same with vb code:

ActiveSheet.UsedRange.EntireRow.Hidden = False
ActiveSheet.UsedRange.EntireRow.AutoFit

and the rows stay hidden. The only way I have found to make a row
visible
is to specifically change the row's hidden property. For example:

Rows(663).Hidden = False

Obviously I can rotate through all the rows, but that is very
inefficient.
The worksheet is not protected. I can delete the rows any time I want.

Any idea why the first two commands above do not work? Using Excel 2003.

Bob

Glad it worked.

Advance Filter (if you filter in place does that) and you don't see the
drop-downs as you do with Auto Filter

"Bob Flanagan" wrote:

Many thanks. Doing Data, Filter, Show All displayed the rows. Strange....
I didn't see any filter set.

Bob

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
It might be due to Advance Filter... Have you tried to clear the filter?

If it does not work then try to change the row hight to a fixed value.

As a last resort, as you said, loop throught the rows and clear the hidden
setting...
"Bob Flanagan" wrote:

I have a number of rows in the middle of my data that are hidden and
whose
height is zero. I have selected the entire sheet and issued both manual
commands (Format, Row, Unhide or autofit) and the row stays hidden. I
have
done the same with vb code:

ActiveSheet.UsedRange.EntireRow.Hidden = False
ActiveSheet.UsedRange.EntireRow.AutoFit

and the rows stay hidden. The only way I have found to make a row
visible
is to specifically change the row's hidden property. For example:

Rows(663).Hidden = False

Obviously I can rotate through all the rows, but that is very
inefficient.
The worksheet is not protected. I can delete the rows any time I want.

Any idea why the first two commands above do not work? Using Excel 2003.

Bob

You won't on Advanced Filter, just on Autofilter.


Gord Dibben MS Excel MVP

On Mon, 26 Jan 2009 19:05:49 -0500, "Bob Flanagan"
wrote:

Many thanks. Doing Data, Filter, Show All displayed the rows. Strange....
I didn't see any filter set.

Bob

"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in
message ...
It might be due to Advance Filter... Have you tried to clear the filter?

If it does not work then try to change the row hight to a fixed value.

As a last resort, as you said, loop throught the rows and clear the hidden
setting...
"Bob Flanagan" wrote:

I have a number of rows in the middle of my data that are hidden and
whose
height is zero. I have selected the entire sheet and issued both manual
commands (Format, Row, Unhide or autofit) and the row stays hidden. I
have
done the same with vb code:

ActiveSheet.UsedRange.EntireRow.Hidden = False
ActiveSheet.UsedRange.EntireRow.AutoFit

and the rows stay hidden. The only way I have found to make a row
visible
is to specifically change the row's hidden property. For example:

Rows(663).Hidden = False

Obviously I can rotate through all the rows, but that is very
inefficient.
The worksheet is not protected. I can delete the rows any time I want.

Any idea why the first two commands above do not work? Using Excel 2003.

Bob