determine if there are hidden rows in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way with vba to determine if
there are hidden rows in a column or range, without
looping through entire range?

tia,
dk
 
You can tell if there are hidden rows using this:
If YourRange.Cells.Count > YourRange.SpecialCells(xlCellTypeVisible).Count
Then
Msgbox "You have hidden cells"
End If
Then you can return the address of the visible ones like this:
MsgBox YourRange.SpecialCells(xlCellTypeVisible).Address
 
Back
Top