Check if Sheet Name exists Then Error or continue Create

[alimsab]

Hi All,

i have the code below which creates a new sheet via data from an inputbox.
i would like to add something to it so that it checks whether a sheet already exists. if so, an error message to display and then inputbox to run again.

Please Login or Register  to view this content.

Thank you.

[LJMetzger]

Hi alimsab,

Try the following function (tested and working):

Please Login or Register  to view this content.

Lewis

[alimsab]

Thanks LJMetzger.
Your code appears to name a sheet name already.
The book I have contains too many sheets so what I'd like is to check allssheet names and display msgbox if it exists at the point the user creates a new sheet via an inputbox and code as above.
Thanks again.
Al

[stnkynts]

Your code appears to name a sheet name already.

He did that as an example for you. Using a little creative deducing you could have arrived at the answer that would have worked in your code

Please Login or Register  to view this content.

Since you seem to need a simplistic answer, here is another option

Please Login or Register  to view this content.

[LJMetzger]

Hi alimsab,

This one may suit your needs better:

Please Login or Register  to view this content.

Lewis