One way:

Public Sub IsItHidden()
MsgBox IIf(Columns(3).Hidden, "", "Not ") & "Hidden"
End Sub

Change column number to suit.


In article ,
Ashman wrote:

G'Day all,

I have a quick question. In a worksheet I have a column which sometimes is
hidden.

How do I use a macro to detect if the column is hidden or not?

Any help would be much appreciated.

Thanks

Jas