Now the error goto works fine and dandy, but only if there is one error ? The reason for this is that VBA can operate in two "modes". Nearly all the time, it operates in "normal" mode. However, when an trappable error occurs and is handled by an "On Error Goto <Label>" statement, execution switches to "error" mode. In this case, no other errors can be trapped until an "Exit Sub/Function/Property"

I have the following code: On Error GoTo cont6: Cells.Find(What:="IP Trinity", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate cont6: I have used this because when the required info is not found I was getting a runtime '91' error message - Object variable