Error not being trapped?

[Phil_V]

Hi I am trying to make sure that I give my worksheet a unique name in the workbook. To do this I create a name that really really really should be unique, but just in case I also try to check it against existing worksheets, and this is where I am having the problem. I thought the following code would trigger the 'goto' on a 'subscript out of range' error (ie. the sheet doesn't exist), and then carry on:

Please Login or Register  to view this content.

However for some reason I am STILL getting the "Run-time error '9' Subscript out of range" box popping up when the code hits the line where I try to assign to temp_str.
I KNOW that the subscript SHOULD be out of range, but my error handler doesn't seem to be error handling very well...

Any ideas?

Thanks!

[EDIT] I should mention that this code is inside a 'For' loop, so will be repeated over and over if that makes a difference.

[royUK]

I use this User Defined Function to check a worksheet name

Please Login or Register  to view this content.

Then something like

Please Login or Register  to view this content.

[Phil_V]

Cheers, looks a lot tidier, I think I'll do something like that
Out of curiosity any idea why the first one doesn't capture the error?
Looking at it further it seems to capture it, and follow the goto correctly on the first pass through the loop, but on the second time through the loop it brings up the erro dialogue.

[royUK]

Not really sure without knowing exactly what you are doing.