Checking Worksheet Name

[Kerrymcc]

Hi I am new to VBA and struggling to get a working code - getting error "sub or function not defined". I basically want to set up validation that there is no worksheet with the same name in the workbook. (the worksheet name is defined from a userform hence the cell reference C2.

Dim stSheetName As String
stSht = Range("C2")
If Not bWorksheetExists(stSht) Then
'Sheet does not exist
'do something
ActiveSheet.Name = Range("C2").Value

Else
'Sheet exists
MsgBox "Details for this product already exist"
End If

End Sub

[barryleajo]

Hello Kerrymcc
Welcome to the forum.
Take a moment to read the rules and learn how to enclose code snippets within code tags.
As well as making your post easier to read/understand it also keeps the moderators at bay!
Its always best to upload a working example to help us understand and debug your problem in context and also prevent long explanations and questions (like this post) and frustrations both ways.
For example, in your code:
.. you don't show a Sub name for your code - does it exist or not?
.. you have DIMed stSheetName but you also need to DIM the other variables e.g. stSht and bWorksheetExists(stSht) before you use them
So a bit more info please?

[Jakobshavn]

See:

https://groups.google.com/forum/?hl=...el/bi_JNLLlkfc

[patel45]

you missed some code, the correct code is this

Please Login or Register  to view this content.

[Kerrymcc]

Hi,

Thanks for the replies, this worked perfectly. Sorry for any confusion!