unhide rows adn columns

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
 
G

Guest

hi nick thanks for the reposne.

i tried this and somehow nothing happens...!
any other suggestion?
thanks
 
N

Nick Hodge

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
[email protected]
 
Top