Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by macro
Is it possible to write a macro that will do an AutoFilter? I need a macro
that will autofilter the same column for the same criteria every time. Anybody? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by macro
Hi,
The simplest way and because of the lack of detail in the question would be for you to record a macro of yourself doing it or you may be able to build on this Range("A1").AutoFilter Field:=1, Criteria1:="JohnDoe" Mike "Rhoswen" wrote: Is it possible to write a macro that will do an AutoFilter? I need a macro that will autofilter the same column for the same criteria every time. Anybody? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by macro
Yes, use the AutoFilter method of the Range object. If you had told us more,
we could have actually constructed the statement for you. Since you didn't, you will have to look the AutoFilter method up in the help files. -- Rick (MVP - Excel) "Rhoswen" wrote in message ... Is it possible to write a macro that will do an AutoFilter? I need a macro that will autofilter the same column for the same criteria every time. Anybody? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by macro
Mike,
Not really much more detail to offer. It's as simple as it seems. You're code is exactly what I needed to build on. Thanks! "Mike H" wrote: Hi, The simplest way and because of the lack of detail in the question would be for you to record a macro of yourself doing it or you may be able to build on this Range("A1").AutoFilter Field:=1, Criteria1:="JohnDoe" Mike "Rhoswen" wrote: Is it possible to write a macro that will do an AutoFilter? I need a macro that will autofilter the same column for the same criteria every time. Anybody? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro filter | Excel Discussion (Misc queries) | |||
filter macro | Excel Programming | |||
Do i use a filter or a macro? | Excel Discussion (Misc queries) | |||
Need macro to filter, create tab on filter and copy/paste | Excel Programming | |||
Need macro to filter, create tab on filter and copy/paste | Excel Programming |