Determine if a row is filtered or not?

[AcousticalConsultant]

Hi,

I'm trying to find a property which lets me know if a row has been "hidden" by a filter or not. I know that I can check the autofilter mode to determine if the autofilter is active, but how do I verify individual rows?

Thanks for the help!
AC

 

[SkipVought]

Check out the Hidden property of the row object.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[AcousticalConsultant]

I thought I had tried that, but couldn't seem to get it to work. I tried it again after reading your post, and now it works... magic! I must be tired. Thanks Skip!

For reference, here is the property:

activesheet.rows.hidden