Object required error

[Brian]

Hi guys,

Im trying to use the inStr function to check a variable (vClose) that has been read into my script from an external excel sheet.

The following piece of code -

Code:

searchString = "/"
Dim tmpVar

If (tmpVar = inStr (1,vClose, searchString, CompareMethod.Text) = 1) then
......
else
....
End If

Im getting an "Object required" error message. anyone know why this is occurring?

Thanks,
Brian