Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using InStr with variables
FWIW, if you'd put Option Explicit before your code, you would have known
that you didn't have intSearch declared as well. "wthomas206" wrote: 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 |