Sub InstrExample() Debug.Print InStr("A Balter", "Balter") 'Returns 8 Debug.Print InStr("Hello", "l") 'Returns 3 Debug.Print InStr("c:\my documents\my file.txt", "\") 'Returns 3End Sub