Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter using macro
Hello friends... I would be very happy if anyone could help me in
this... I want to write a macro to autofilter a particular column the input given will be some string the output i should get is all the entries containing that string in that particular column. I have used the below line for autofilter, but the problem is the crieteria it takes is "equal", i want to put the critieria as "content" which means i should get all the entries CONTAINING the particular entry. Selection.AutoFilter Field:=1, Criteria1:="customer" any inputs?????? Thanks!!!!!!!! Anil ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter using macro
Anil,
Try Selection.AutoFilter Field:=1, Criteria1:="*customer*" * is a wild card that matches any sequence of characters, including none. -- John Green - Excel MVP Sydney Australia "kkanil" wrote in message ... Hello friends... I would be very happy if anyone could help me in this... I want to write a macro to autofilter a particular column the input given will be some string the output i should get is all the entries containing that string in that particular column. I have used the below line for autofilter, but the problem is the crieteria it takes is "equal", i want to put the critieria as "content" which means i should get all the entries CONTAINING the particular entry. Selection.AutoFilter Field:=1, Criteria1:="customer" any inputs?????? Thanks!!!!!!!! Anil ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter Macro | Excel Worksheet Functions | |||
Autofilter from macro | Excel Discussion (Misc queries) | |||
Macro using autofilter | Excel Discussion (Misc queries) | |||
Keep autofilter after macro is run | Excel Worksheet Functions | |||
Autofilter Macro Help | Excel Discussion (Misc queries) |