ExcelBanter - Hide / unhide column in VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hide / unhide column in VBA (https://www.excelbanter.com/excel-programming/317262-hide-unhide-column-vba.html)

Patrick

Hide / unhide column in VBA

How do i hide and unhide a column using VBA
Thanks

--
Patrick

Ron de Bruin

Hide / unhide column in VBA

Hi Patrick

Sheets("sheet1").Columns("A:C").EntireColumn.Hidde n = True

False to get them back

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Patrick" wrote in message ...
How do i hide and unhide a column using VBA
Thanks

--
Patrick

Bob Phillips[_6_]

Hide / unhide column in VBA

With Worksheets("Sheet1").Columns("A")
.Hidden = Not .Hidden
End With

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Ron de Bruin" wrote in message
...
Hi Patrick

Sheets("sheet1").Columns("A:C").EntireColumn.Hidde n = True

False to get them back

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Patrick" wrote in message
...
How do i hide and unhide a column using VBA
Thanks

--
Patrick

All times are GMT +1. The time now is 05:16 PM.