determine if there are hidden rows in a column

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a faster way to update values selected by advanced filter 2
determine if column is frozen with vba 4
Problem with a loop and column references 27
Delete rows based on contents of Col A 0
Rows in named range? 5
determine if sheet contains mergearea(s) 4
Make protected hidden row & column headers appear and rehide based ona cell's value 2
How many rows are hidden? 2

Top