determine if there are hidden rows in a column
 

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

determine if there are hidden rows in a column
 

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
--
Charles Chickering

"A good example is twice the value of good advice."


"dk" wrote:

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