On Error Problem...

[Mhz]

Hi,

I am trying to adapt an input box that will create a new Worksheet, and assign
the new sheet the name put in the input box.. That works ok, but I am
trying to MessageBox an Error if the Worksheet name already exists before
it creates the new worksheet.

The code I am presenting partially works;
It will Message Box the Error even if the Worksheet name doesn't exist.
And It creates the new sheet regardless..

Could someone show me any corrections to fix the problems I am getting with
This Code.. Thanks For Any Help On This..

[jetted]

Hi

I would try something like this

Please Login or Register  to view this content.

[Mhz]

Hi Jetted,

That one is not working for me.. I get no response on error, nor does a new
sheet get created. Thanks for the input..

[VBA Noob]

Maybe this will help.

It use a seperate function to check if sheet exists

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

[Mhz]

Yes VBAnoob, That works out good for me now.. I modified the new sheet
with my copy functions and its working error free .. THNAKS ALOT! ..

[VBA Noob]

Glad it helped

VBA Noob