cannot unhide rows!

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cannot unhide rows/columns in the worksheet. 1
unhide rows adn columns 3
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Identify Hidden Columns - New issue! 19
Macro to Hide/Unhide various columns 5
Unhiding rows based on another cell value 5
Problem Unhidding columns/rows in excel using VBA 4
Sort partially hidden data 1

Back
Top