What if AutoFilter is NOT on?

E

Ed

I've spent some time here getting tips and code on incrementing through an
AutoFiltered range. Thanks to the great efforts of good people much smarter
than I, these macros work wonders for me. Now I "broke" one - by trying to
use it on an UNfiltered workbook! It errored on the line:
Set rng = ActiveSheet.AutoFilter.Range


What is the best way to handle this? On Error Resume Next? Or is there a
test: "If AutoFilter = True Then"?

Ed
 
N

Norman Jones

Hi Ed

To Test for an autofilter, you can use the AutofilterMode property::

If Activesheet.AutoFilterMode Then
'There is an autofilter
'Do something
Else
'No autofilter
'Do something else
End If

If you need to check if any rows are hidden by a filter, use the FilterMode
property.
 
E

Ed

Thanks, Norman. I appreciate the boost.

Ed

Norman Jones said:
Hi Ed

To Test for an autofilter, you can use the AutofilterMode property::

If Activesheet.AutoFilterMode Then
'There is an autofilter
'Do something
Else
'No autofilter
'Do something else
End If

If you need to check if any rows are hidden by a filter, use the FilterMode
property.
Click to expand...
 
Top