View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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
|