View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Unhiding Rows: bug in Excel?

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