View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed[_18_] Ed[_18_] is offline
external usenet poster
 
Posts: 118
Default 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