| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel macro filter Like keyword
I am trying to program a filter so that it searches a keyword among a string
of characters in my first column I used a combo to feed a linked cell. I have the following code: Private Sub ComboBox1_Change() SourceRange.AutoFilter Field:=1, Criteria1:="Like & " * "& A1 & " * "" End Sub I have a type mismatch error. Any help would be great! My criterion (linked) cell is A1 Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/201003/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro that concatenates content from cells if given keyword is found | Excel Programming | |||
| Selecting a Keyword for Macro: | Excel Worksheet Functions | |||
| Macro - reads cells in a column .If keyword found moves cell conte | Excel Programming | |||
| Macro searches for keyword. If found , puts 0 in cell from next co | Excel Programming | |||
| Filter list in place if a cell has a keyword within a formula | Excel Programming | |||
Threaded Mode
