This was a documented problem in Excel 97
http://support.microsoft.com/default...&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.
--
Regards,
Tom Ogilvy
Jos Vens wrote in message
...
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