View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default Autofilter - Toggles OFF ?

In a worksheet when opened I have a table with auto-filter turned on
(showing the drop-down arrows for each of the 15 fields).

When I run a macro to update the sheet, when complete the auto-filter
Is not applied. I immediately run the macro again, and the auto-filter
Is back -- So obviously with these lines of code this is the natural
occurrence.

.....
With ActiveSheet
.Range("A5").AutoFilter
End With

So I changed the above to:
Thinking the new line would always set the a/f to True,

With ActiveSheet
.Range("A5").AutoFilter
.FilterMode = True
End With

But it doesn't. What must I do to have auto-filter ALWAYS ON
After repeated runs of my macro?

Thanks for any help..