show all columns in a worksheet
 

Hi,

I have a worksheet that will have some columns hidden dynamically from
time to time. Is there a reliable way via VBA to unhide all columns
automatically?

Thanks a lot for your input.


--
huangx06
------------------------------------------------------------------------
huangx06's Profile: http://www.excelforum.com/member.php...o&userid=25014
View this thread: http://www.excelforum.com/showthread...hreadid=385699

show all columns in a worksheet
 

Cells.Select
Selection.EntireColumn.Hidden = False


--
pkohler
------------------------------------------------------------------------
pkohler's Profile: http://www.excelforum.com/member.php...fo&userid=8919
View this thread: http://www.excelforum.com/showthread...hreadid=385699

show all columns in a worksheet
 

activesheet.columns.hidden=false

--
HTH

Bob Phillips

"huangx06" wrote in
message ...

Hi,

I have a worksheet that will have some columns hidden dynamically from
time to time. Is there a reliable way via VBA to unhide all columns
automatically?

Thanks a lot for your input.


--
huangx06
------------------------------------------------------------------------
huangx06's Profile:
http://www.excelforum.com/member.php...o&userid=25014
View this thread: http://www.excelforum.com/showthread...hreadid=385699