| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off a filter before running a macro
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off a filter before running a macro
Range("P:P").AutoFilter Field:=1
-- Ian -- "Arno" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off a filter before running a macro
Try,
Range("P:P").AutoFilter Field:=1 Mike "Arno" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off a filter before running a macro
Thank you Ian !
"IanC" wrote: Range("P:P").AutoFilter Field:=1 -- Ian -- "Arno" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off a filter before running a macro
Thank you Mike !
"Mike H" wrote: Try, Range("P:P").AutoFilter Field:=1 Mike "Arno" wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off a filter before running a macro
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 "Arno" wrote: Thank you Mike ! "Mike H" wrote: Try, Range("P:P").AutoFilter Field:=1 Mike "Arno" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to allow auto filter after running password protect | Excel Discussion (Misc queries) | |||
| Advanced Filter works in recorder but not while running macro | Excel Programming | |||
| Macro help! Selecting rows after running a filter | Excel Programming | |||
| turn off filter | Excel Worksheet Functions | |||
| paste into filter criteria box running macro | Excel Programming | |||
Linear Mode
