VBA code not returning correct string using MID and InStr

i cannot get this to return the string I want.
Cell F1 contains text: Ship-To: (23) DAVIDSON FAMILY HEALTH SCIENCE
My desire: return to cell b3 the text beginning 2 places after the position of the close parenthesis
In excel spreadsheet, this formula returns the correct text =MID(F1,FIND(")",F1)+2,LEN(F1)-FIND(")",F1))
The desired string to return would be: DAVIDSON FAMILY HEALTH SCIENCE
What I am getting returned to cell B3 is: hip-To: (23) DAVIDSON FAMILY HEALTH SCIENCE
Why is only the first character of the text in F1 being stripped off?

The position of the Close Parenthesis and the length of the string in F1 will vary with each data set, so I can't just hard code in a certain number of characters from the right end of the string in F1.

Any help would be appreciated, I'm sure I am just missing something simple...

Please Login or Register  to view this content.

I copied over your changes Dim n and initializing it. Now I am getting the complete text from cell F1 loaded into cell B3. I tracked through the Locals window and see that the value of n is never changing from Zero. I will try relooking at this tomorrow, getting late enough tonight my eyes are fuzzy. Thanks for your help!