Confirm Worksheet does not exist

[unreal_event_horizon]

Hi All (again) lol

i have a quick query, looking to do the following,

i have a piece of code that names a new work sheet after a cell value.

if the user enters the same date that has a sheet that already exists in the workbook then it crashes out with the "same name" error.

What i have been trying to do is implement a check to see if the cell value which i pass to a string already exists. but im not sure how to check all worksheets and see if the name is already there.

if someone could give me a pointer it would be greatly appreciated.

many thanks
Dave

[AB33]

Please Login or Register  to view this content.

[TMS]

In a new workbook, Sheet1 will exist and Sheet4 will not exist.

Please Login or Register  to view this content.

Regards, TMS

[HaHoBe]

Hi, Dave,

Please Login or Register  to view this content.

Ciao,
olger

[unreal_event_horizon]

RIght im totally lost,

my code below, as it has been given by someone working with me for review, i simply added a sheet name part as they recorded the whole thing and i did a quick tidy and added a quick enter date check at the start.

Please Login or Register  to view this content.

I thought the check would have been something similar to

Please Login or Register  to view this content.

should i be using an error check or a do while loop?

i relatively new to vba and spend a good bit of time with vb.net but im a total novice...

so im happy for all advice as i like to try and get there myself in the end

[AB33]

Please Login or Register  to view this content.

[TMS]

With the function that I provided, your code would look like:

Please Login or Register  to view this content.

Regards, TMS

[unreal_event_horizon]

have it working now, many thanks for all your input.

I have a question if anyone wants to give me a quick explanation. the code in the tags is the working code.

but i want to know in basic english what this is telling me.....

Please Login or Register  to view this content.

am i right in thinking, if the sheet name does not exist then.......

could i be so rude to ask for this line to be broken down better than that?

Please Login or Register  to view this content.

[AB33]

In plain English yes

[unreal_event_horizon]

With the function that I provided, your code would look like:

Please Login or Register  to view this content.

Regards, TMS

apologies for not testing, this TMS, when creating a function, do i create a new module, save the function in there and call it back like any other macro by name when i want to use it?

[unreal_event_horizon]

Reputation added to all, many thanks for your input

Dave

[TMS]

You're welcome. Thanks for the rep.

when creating a function, do i create a new module, save the function in there and call it back like any other macro by name when i want to use it?

Essentially, yes. Doesn't have to be in its own module but I consider it best practice. If you rename the module, it's easier to find things.

Regards, TMS