after you goto 1000, use a Resume xxxx statement in the 1000 section of your
code which resets the error handler.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

Signature
"jon" wrote in message
...
I have an automated system to rename every sheet in a
workbook. This often incurs an error when the name is
duplicated and to get round this i used

on error goto 1000

which sorts it out very satisfactorily. The problem is
that this only works once when the macro is run. I have
tried repeating this line when it comes back out of the
code to ammend the error in the vain hope that it would
re-apply the rule. I can't even find anything in the
help file so any advice would be appreciated.

Tia

Jon