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.

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.

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.