Unhiding Rows: bug in Excel?

[Jos Vens]

Hi,

Is it possible to unhide a row in an invisible range or is it a bug in Excel
2000? In each case, Excel crashes if you do so

Suppose rows 1 to 20 are visible, the other rows are hidden. I try to
unhide row 30

Rows(30).Hidden = False

Now excel crashes!

I only can work around by unhiding all rows, and thereafter hide rows 21-29
and 31 to 65xxx (last row)

Bug or not?

Thanks
Jos Vens
(e-mail address removed)

 

[Tom Ogilvy]

This was a documented problem in Excel 97

http://support.microsoft.com/default.aspx?scid=kb;en-us;159947&Product=xlw97
XL97: Illegal Operation Unhiding a Row with a Macro

I didn't find anything saying it continues in xl2000, but perhaps it does.

 

[Jos Vens]

Thanks Tom,

I believe the error is not corrected in Excel 2000!

Jos Vens

 

[Tom Ogilvy]

Note that the article did describe a workaround using row height.