cannot unhide rows!

G

Guest

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
 
J

Jim Rech

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
| 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
|
 
Top