Is column hiden?

[ianripping]

Is there a command in VBA that can query if a column is hidden or not?

Eg if col a is hidden then goto loc1 else goto loc

 

[ehntd]

Take a look at this:

http://www.dicks-blog.com/excel/2004/10/determine_if_ce.htm

 

[Robin Hammond]

Ian,

This should be easily adaptable.

Function HiddenCellsInRange(rngTest As Range) As Boolean
Dim vCell As Variant
For Each vCell In rngTest
If vCell.EntireRow.OutlineLevel > 1 Or _
vCell.RowHeight <= 0 Or vCell.ColumnWidth <= 0 Then
HiddenCellsInRange = True
Exit Function
End If
Next vCell
End Function

Robin Hammond
www.enhanceddatasystems.com