I kept getting the following error message when I ran my macro to find a
string in a worksheet range:

Run-time error '9': Subscript out of range

The debugger point the error to the following line of code:

Set foundPilot = Worksheets("Pilot
Costs").Range("A1:B100").Find(What:="Pilot Total", LookIn:=x1Values)

Tried different strings to find and changed the range but kept getting
the same error. Error msg seems to indicate I have an array
subscripting problem but I am not using arrays in the code. Help!



--
vbarookie
------------------------------------------------------------------------
vbarookie's Profile: http://www.excelforum.com/member.php...o&userid=31789
View this thread: http://www.excelforum.com/showthread...hreadid=524195