Hi,
I wanna check the value of every visible cell in an filtered data. To move along the filtered data I was using the below formula
This works fine, but prob is my sheet has 6000+ value, due to which the macro files hang. Is there a shorter way of doing this and achive the same result.![]()
Do Activecell.Offset(1,0).Select Loop While Activecell.EntireRow.Hidden = True
Thanx for any help.
Bookmarks