Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find a string match in a column
Hi,
I am wanting to find a string from a column which matches my variable. I modified this code of Tom Ogilvy's in a related answer For Each cell In rngA res = Application.Match("*" & cell.Value & "*", rngB, 0) If Not IsError(res) Then Set rng = rngB(res) rng.Offset(0, 1).Value = cell End If to For Each cell In rngA res = Application.Match(myVar, MyRng) If Not IsError(res) Then myCode End If next but I get a number in res that in fact is a blank cell. Can't work out what is happening. Any help appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup to find a match in a string | Excel Worksheet Functions | |||
How to find last match in a column? | Excel Discussion (Misc queries) | |||
Find a string within a column | Excel Discussion (Misc queries) | |||
Find text string in column? | Excel Discussion (Misc queries) | |||
Trying to find string in a column or row | Excel Programming |