unhide rows adn columns

  • 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

thanks in advance
 
Try

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
hi nick thanks for the reposne.

i tried this and somehow nothing happens...!
any other suggestion?
thanks
 
Did you write the code or is this commercial? That is the syntax for
unhiding rows and columns. All I can think is that the worksheet is
protected and the error (1004) is being trapped and handled or there is some
event code that is re-hiding them

Anyone else?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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! 1
cannot unhide rows/columns in the worksheet. 1
Excel 2007 - Hide & Unhide Columns/Rows 8
Cannot unhide the hidden rows in my spreadsheet 3
Hide and Unhide Function 4
Unhide columns and rows 2
Why do hidden columns/rows unhide automatically? 1
Unhide columns 2

Back
Top