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