Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find "386", but not "386c"
Using VBA (in Excel 2003), I want to find the next occurrence of a string.
If I'm searching for the string "386", I don't want to find "386c" for example. If someone could get me an example of the code to use, I would be very grateful. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find "386", but not "386c"
You do not specify what and how you are searching but if it is worksheet
cells then set the following parameter. LookAt:=xlWhole -- Regards, Nigel "Maxx" wrote in message ... Using VBA (in Excel 2003), I want to find the next occurrence of a string. If I'm searching for the string "386", I don't want to find "386c" for example. If someone could get me an example of the code to use, I would be very grateful. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find "386", but not "386c"
Nigel,
Thank you for answer. That did the trick. Maxx "Nigel" wrote in message ... You do not specify what and how you are searching but if it is worksheet cells then set the following parameter. LookAt:=xlWhole -- Regards, Nigel "Maxx" wrote in message ... Using VBA (in Excel 2003), I want to find the next occurrence of a string. If I'm searching for the string "386", I don't want to find "386c" for example. If someone could get me an example of the code to use, I would be very grateful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |