If sheets has already name than show msgbox

[HaroonSid]

hello
i want if there is already sheet with name of C7.value than pop up a msgbox with yes or no option
thanx
code is here :

Please Login or Register  to view this content.

[Miroslav R.]

Hi tehre,

nothing more,mothing less than looping through all sheets:

Please Login or Register  to view this content.

[HaroonSid]

its not working

[Miroslav R.]

It was only a suggestion,not a real example. To make it work properly I have to know in which part of your code it has to be written. And the most efficient way is to upload sample workbook

[stnkynts]

You don't need to loop through each worksheet to see if a sheet exists. Something like this will do that. However it is hard to tell what the OP wants beyond his initial question. Maybe this:

Please Login or Register  to view this content.

[HaroonSid]

hello stnkynts

u have reverse ur code, because according to Range("C7"). if C7.VALUE = 18 and i run code than code create a sheet with name 18, now if i click again than its also creating a file with name sheet1, sheet2, sheet3............

check ur code

[HaHoBe]

Hi, haroon2015,

Please Login or Register  to view this content.

Ciao,
Holger

[HaroonSid]

Hello Holger

thanx a lot, Simply Just Awesome

will add u reputation