Find "386", but not "386c"

  • Thread starter Thread starter Maxx
  • Start date Start date
M

Maxx

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.
 
You do not specify what and how you are searching but if it is worksheet
cells then set the following parameter.

LookAt:=xlWhole
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What was the first PC Game you remember playing? 14
Resize Sumif formula parameters for added data 6
A Tale of Two Cities- Find and add 3
Interactive Find and Copy 3
find 1
Find a subfolder? 1
Re .FIND() 4
Set range, perform operation, set new range, repeat 1

Back
Top