Auto Filter

[moni_tm]

Good Morning,

I have a Macro that removes the the auto filter from a sheet, i would then like to re add the the auto filter to "$B$5:$J$5"

Any ideas?

Please Login or Register  to view this content.

Thank you

Tom

[BadlySpelledBuoy]

Not tested, but perhaps something along the lines of:

Please Login or Register  to view this content.

BSB

Range("B5:J5").AutoFilter