Is column hiden?
 

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

--
ianrippin

-----------------------------------------------------------------------
ianripping's Profile: http://www.excelforum.com/member.php...nfo&userid=320
View this thread: http://www.excelforum.com/showthread.php?threadid=27555

Is column hiden?
 

Take a look at this:

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

--
ehnt
-----------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...fo&userid=1586
View this thread: http://www.excelforum.com/showthread.php?threadid=27555

Is column hiden?
 

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

"ianripping" wrote in message
...

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 loc2


--
ianripping


------------------------------------------------------------------------
ianripping's Profile:
http://www.excelforum.com/member.php...fo&userid=3209
View this thread: http://www.excelforum.com/showthread...hreadid=275553