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