Duplicate Sheets

[Vetequk]

I have written some code which asks the using for a name, selcet's a sheet, copy's the sheet, rename's the copied sheet then hide's the original sheet and makes the copied sheet with new name active.

My problem is that I need some sort of code to check for sheets with duplicate names and if true ask the user to rename the sheet or maybe delete the sheet.


Thanks

Vetequk

[shasur]

You can check if the name exists already in the given workbook

Please Login or Register  to view this content.

[royUK]

Use this User Defined Function

Please Login or Register  to view this content.

For example

Please Login or Register  to view this content.

[Vetequk]

This is the code I am using, how can I make this work?

Please Login or Register  to view this content.

After this code I have a list of Elseif for excel to search for the correct sheet to copy and rename.

Thanks
Vetequk

[Vetequk]

I am a novice at this programming stuff, however I lookedup user difined functions and have worked it out.

Thanks

Vetequk