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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instr | Excel Programming | |||
instr() ? | Excel Programming | |||
InStr | Excel Programming | |||
InStr | Excel Programming | |||
InStr and ADO | Excel Programming |