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