Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA autofilter
I am writing a macro for autofilter. The code is (taken from one community):
Dim FiltRng As Range Worksheets(Choice).Cells.ClearContents rng.AutoFilter Field:=Field, Criteria1:=Choice On Error Resume Next Set FiltRng = rng.SpecialCells(xlCellTypeVisible).EntireRow On Error GoTo 0 FiltRng.Copy Worksheets(Choice).Range("A1") Set FiltRng = Nothing This code is taking search string from userform. It is working fine to search exact cell contents. However I want to search the records even if that word is part of the cell. e.g. if I write "Europe" then it should also search the cells which have "Europe" word, even if there are additionals words in the cell. How can we do this? Thank You Regards, Pawan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |