Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Values in Cell
If i have a cell that has the values - A,C,D
How do I do a find using vba: Set rngFound = rngToSearch.Find(What:="A", _ LookIn:=xlFormulas, _ LookAt:=xlWhole, _ MatchCase:=False) That line finds the cells with Just A but i need to also find cells where A is with other values. Even the Control+F doesnt find the cell when it has A,C,D in it. Anyone know? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Values in Cell
Change
LookAt:=xlWhole to LookAt:=xlPart In article .com, "RigasMinho" wrote: If i have a cell that has the values - A,C,D How do I do a find using vba: Set rngFound = rngToSearch.Find(What:="A", _ LookIn:=xlFormulas, _ LookAt:=xlWhole, _ MatchCase:=False) That line finds the cells with Just A but i need to also find cells where A is with other values. Even the Control+F doesnt find the cell when it has A,C,D in it. Anyone know? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find One Of Several Values Within A Cell | Excel Worksheet Functions | |||
UDF code to find specific text in cell comments, then average cell values | Excel Programming | |||
find partial values in cell | Excel Worksheet Functions | |||
Find numerical values in one cell,within another cell- is it possi | Excel Programming | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |