Using InStr with variables

[wthomas206]

How do I use the InStr function with variables?
Dim intStart as integer
Dim strSearch as string
Dim strSought as string

strSearch = Range("E2").Value 'Cell value is PO Box 111 LAKEBAYWA 98349
strSought = Range("F2").Value 'Cell value is LAKEBAY

intStart = InStr(intSearch, strSought) ' intStart returns 0

 

[Barb Reinhardt]

Um ... you haven't defined intSearch

 

[Jacob Skaria]

Try
intStart = InStr(strSearch, strSought)

If this post helps click Yes