I think I have it, BUT, does anyone know of any other invalid characters?

Private Function SheetNameFilter(argName As String) As String
'REMOVES INVALID CHARACTERS FROM A POTENTIAL SHEET TAB NAME STRING
Dim sClean As String
sClean = Replace(argName, "*", "", 1, , vbTextCompare)
sClean = Replace(sClean, "[", "")
sClean = Replace(sClean, "]", "")
sClean = Replace(sClean, "\", "")
sClean = Replace(sClean, "/", "")
sClean = Replace(sClean, "?", "")
Do While InStr(sClean, " ") 0
sClean = Replace(sClean, " ", " ") 'remove double spaces
Loop
SheetNameFilter = sClean
End Function


"quartz" wrote:

I am using Office 2003 on Windows XP.

1) Could someone please post a list of characters that cannot be used in a
sheet tab name?

2) I need a function that then tests for these invalid characters and
removes them from a string...

3) Thanks much in advance for your assistance.