Hi there

Getting a bit rusty with VBA - I'm sure I would have solved this myself
a while back!

I am testing some workbooks for specific text strings. If the strings
exist its an error and the macro should stop and report. If there are
no strings thats fine - move to the next test.

Can someone give me a pointer as to how to construct the error handling
in this instance?



I'm looking to wrap something around this:

Sheets.Select
Cells.Find(What:="not a valid", After:=ActiveCell,
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
_
MatchCase:=False, SearchFormat:=False).Activate
On Error GoTo ErrorTrap1

Any suggestions appreciated...
Neil


--
frango_head
------------------------------------------------------------------------
frango_head's Profile: http://www.excelforum.com/member.php...o&userid=33355
View this thread: http://www.excelforum.com/showthread...hreadid=531864