VBA Senses if a cell is hidden

[leydorfs]

VBA is iterating a spreadsheet and I would like VBA to sense if the a cell is hidden

 

[Rick Rothstein]

VBA is iterating a spreadsheet and I would like VBA to sense if the a cell is hidden

The Range object has a Hidden property that you can use. Something like this...

Dim Cell As Range
For Each Cell In Range("A1:A99")
  If Cell.Hidden Then
    ' The cell is hidden
  Else
    ' The cell is visible
  End If
Next