ExcelBanter - cannot unhide rows!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - cannot unhide rows! (https://www.excelbanter.com/excel-programming/305708-cannot-unhide-rows.html)

No Name

cannot unhide rows!

how can i unhide rows and columns. this doenst work:
Rows("1:2000").EntireRow.AutoFit
Columns("F:H").EntireColumn.AutoFit
Rows("1:2000").Hidden=False
Columns("F:H").Hidden=False

please suggest something

thanks in advance

Jim Rech

cannot unhide rows!

Columns("F:H").Hidden = False
Rows("1:2000").Hidden = False

work fine for me to unhide rows and columns on the active, and unprotected,
worksheet..

--
Jim Rech
Excel MVP
wrote in message
...
| how can i unhide rows and columns. this doenst work:
| Rows("1:2000").EntireRow.AutoFit
| Columns("F:H").EntireColumn.AutoFit
| Rows("1:2000").Hidden=False
| Columns("F:H").Hidden=False
|
| please suggest something
|
| thanks in advance
|

All times are GMT +1. The time now is 10:56 PM.