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

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

Thanks Tom,

I believe the error is not corrected in Excel 2000!

Jos Vens


"Tom Ogilvy" schreef in bericht
...
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

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

--
Regards,
Tom Ogilvy


"Jos Vens" wrote in message
...
Thanks Tom,

I believe the error is not corrected in Excel 2000!

Jos Vens


"Tom Ogilvy" schreef in bericht
...
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