Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using InStr with variables
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using InStr with variables
Um ... you haven't defined intSearch
"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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using InStr with variables
Try
intStart = InStr(strSearch, strSought) If this post helps click Yes --------------- Jacob Skaria "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 |