What if AutoFilter is NOT on?
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
|