If you not see one with "missing" in it it is OK

Do you have the same problem if you try it in another workbook

Sub aaa()
Dim myString As String

myString = "12345"
MsgBox Left(myString, Len(myString) - 1)

End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Blaine" wrote in message ...


Ron,

Ok, I have the following check marked under Tools-References:

"Visual Basic for Applications"
"Microsoft Excel 12.0 Object Library"
"OLE Automation"
and
"Microsoft Office 12.0 Object Library"


*** Sent via Developersdex http://www.developersdex.com ***