Turn off a filter before running a macro

[Arno]

Hello,

I need a macro that before running turn off a filter in column "P"

Can you Please tell me the syntax to write this.


Thank you ! Arno

 

[IanC]

Range("P").AutoFilter Field:=1

 

[Mike H]

Try,

Range("P").AutoFilter Field:=1

Mike

 

[Arno]

Thank you Ian !

Range("P").AutoFilter Field:=1

 

[Arno]

Thank you Mike !

Try,

Range("P").AutoFilter Field:=1

Mike

 

[Mike H]

Arno,

Glad I could help. Here's a tip, if your unsure of the syntax for something
like this simply record youself doing it with the macto recorder.

Mike