View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default search a string withing a string : find / search hangs

Hi Itarnak,

Look at the InStr function in VBA help.


---
Regards,
Norman



"itarnak" wrote in
message ...

hi,

i want to know if a string is within another string. If i use
find/search, the function hangs if the string is not found.....instead
of return an "not found code", as i expected...


So which function to use to find a string in another one?


Regards,
iTarnak


--
itarnak
------------------------------------------------------------------------
itarnak's Profile:
http://www.excelforum.com/member.php...o&userid=27865
View this thread: http://www.excelforum.com/showthread...hreadid=478738