excelpinto
Board Regular
- Joined
- Feb 14, 2008
- Messages
- 53
Hey all,
I'm using the autofilter to dynamically sort some data. Here's what I'm looking to do: If I apply the filter, and I get at least one filtered row (doesn't matter how many or what it is), I apply some formatting. If criteria applied to the autofilter results in no rows returned, no formatting.
I just dont know how to check for the presence of any row being returned after the criteria is applied? Any ideas/examples? Thx.
I'm using the autofilter to dynamically sort some data. Here's what I'm looking to do: If I apply the filter, and I get at least one filtered row (doesn't matter how many or what it is), I apply some formatting. If criteria applied to the autofilter results in no rows returned, no formatting.
I just dont know how to check for the presence of any row being returned after the criteria is applied? Any ideas/examples? Thx.