on error error
 

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

on error error
 

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

on error error
 

Try using On Error Resume Next, and check the Err object after the rename to
see if it has worked or not.

You should also disable the error handler at the end, On Error Goto 0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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