Autofilter on/off function

[JimM]

I've written a macro, part of which filters a list of data. Prroblem I'm having is that it works fine if there isn't already an autofilter on the data but if it is auofiltered then the macro effectively switches removes this and then falls over with the field and criteria line.

Is there a line of VBA code that I could put in so that it always starts with the data 'non-filtered' and then runs through as it should

Thanks

Jim

 

[gingersteve]

Sheets("Sheet1").autofiltermode=false

 

[JimM]

Perfect !

Thanks