Hi Gary's Sudent,

For xl2k == look at the InStr function in VBA help.


BTW, Why does Gary never give you an answer?

---
Regards,
Norman



"Gary's Student" wrote in message
...
If Str1 and Str2 are strings, is there a function or simple coding within
VBA
to return TRUE if Str1 is a substring of Str2, otherwise FALSE?

Thanks in advance
--
Gary's Student