Hi Leith,

How do I use your function within my if statement? The reason I ask is because I expanded my macro into multiple if statements as shown below:

Do
ShowInputBoxEnterNewWSName:
        strNewWSName = Application.InputBox(Prompt:="Enter a name for the New Worksheet...", Title:="", Type:=2)
            If strNewWSName = "False" Then Exit Sub
            If IsFilenameValid(strNewWSName) ....Then 'I want to use it here if possible
                MsgBox Prompt:="Special Characters are not allowed as part of a worksheet name.", _
                Buttons:=vbExclamation, Title:=""
                GoTo ShowInputBoxEnterNewWSName
            End If
            If strNewWSName = "" Then
                MsgBox Prompt:="You must enter a Worksheet Name...", Buttons:=vbExclamation, Title:=""
            ElseIf WorksheetExists(strNewWSName) Then
                MsgBox Prompt:="Worksheet " & Chr(34) & strNewWSName & Chr(34) & " already exists! ", _
                Buttons:=vbExclamation, Title:=""
            strNewWSName = ""
            End If
    Loop Until strNewWSName <> ""
I appreciate the help!