The string that your code line produces, looks sensible, ( In a manner of speaking ) , to me also...
I am not quite sure what you are asking, but The Evaluate( ) takes a string argument
If you just put Join(Array(Chr(199), Chr(225), Chr(205), Chr(207), Chr(237), Chr(203)), Empty) in it, then it is going to be looking for a worksheet thing that looks like the text that your Join(Array(Chr(199), Chr(225), Chr(205), Chr(207), Chr(237), Chr(203)), Empty) creates.
Of course it wont find anything with that name
A string inside Evaluate( ) itself , will need to have an extra quote each side, ....
I think you have had this issue a few times already...
The string to evalute must look sensible to Evaluate - it must look like a string, so you really should by now be in the habit of looking at the string you have, before you put it into Evaluate, to make sure it looks like what you want Evaluate to see
Code: Select all
Dim v
v = Join(Array(Chr(199), Chr(225), Chr(205), Chr(207), Chr(237), Chr(203)), Empty)
Dim strEval As String
Let strEval = """" & Join(Array(Chr(199), Chr(225), Chr(205), Chr(207), Chr(237), Chr(203)), Empty) & """"
Debug.Print strEval
v = Evaluate("""" & Join(Array(Chr(199), Chr(225), Chr(205), Chr(207), Chr(237), Chr(203)), Empty) & """")
End Sub
You don't want Evaluate to see that
Callie
stuff
You want it to see
"Callie"
I am having difficulty logging in with this account just now.
You can find me at DocAElstein also