Macros and auto filter

[misslisaann]

When I set my macros I included auto filters. When I run the macro it leaves the auto filter on. I then choose data-filters and uncheck auto filter and it reverts back to the original. How can I get my macros to run using auto filter and save the data with the autofilter not showing. I have windows xp with excel 2002

 

[Datsmart]

Welcome to the board Misslisaann,

If what you are asking is how to turn off autofilter as your macro completes, just put the following line of code at the end of your macro;
Worksheets("Sheet1").AutoFilterMode = False
Be sure to change the sheetname to what you are using.

 

[Chas17]

..

If Worksheets("Sheet1").AutoFilterMode Then Selection.AutoFilter

will turn off filters if they were on., then save wb

Chas