ExcelBanter - Hide Column AD

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

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

- - Hide Column AD (https://www.excelbanter.com/excel-programming/431891-hide-column-ad.html)

I am looking for the ability (in vba) to hide column AD without actually
selecting it.

activesheet.range("AD1").entirecolumn.hidden = true

"Patrick C. Simonds" wrote:

I am looking for the ability (in vba) to hide column AD without actually
selecting it.

--

Dave Peterson

Here is another way...

ActiveSheet.Columns("AD").Hidden = True

By the way, the sheet doesn't have to be active to do this. Assuming Sheet1
is the ActiveSheet, here is how to hide Column AD on Sheet2...

Worksheets("Sheet2").Columns("AD").Hidden = True

or, if you want to do it via a variable...

WSname = "Sheet2"
Worksheets(WSname).Columns("AD").Hidden = True

--
Rick (MVP - Excel)

"Patrick C. Simonds" wrote in message
...
I am looking for the ability (in vba) to hide column AD without actually
selecting it.