Need help with Application.Evaluate

[dryper]

I have the following line in a function called GRADER, which keeps returning an error:

GRADER = Application.Evaluate("VLOOKUP(" & a.Address & ",{0,"U";0.5,5;0.6,4;0.65,3;0.7,2;0.75,1},2)")

It seems that the error is due to the quotes around the string "U". So is there any other way to embed a string within another string?

Thanks for viewing.

 

[Marcelo Branco]

Try this

Double the quotes

GRADER = Application.Evaluate("VLOOKUP(" & a.Address & ",{0,""U"";0.5,5;0.6,4;0.65,3;0.7,2;0.75,1},2)")

HTH

M.

 

[dryper]

Strange how it is interpreted, but works nonetheless.. thanks!

 

[Marcelo Branco]

Strange how it is interpreted, but works nonetheless.. thanks!

You are welcome and tks for the feedback.

Comment:
Some people prefer to use Chr(34) instead of doubling the quotes

GRADER = Application.Evaluate("VLOOKUP(" & a.Address & ",{0," & _
    Chr(34) & "U" & Chr(34) & ";0.5,5;0.6,4;0.65,3;0.7,2;0.75,1},2)")

I dont like it - a matter of taste.

M.

 

[Rick Rothstein]

Strange how it is interpreted, but works nonetheless.. thanks!

VB uses quote marks to delineate text constants... anything between a set of quote marks are a text constant (that is, a collection of text characters). The problem with putting one or more single quote marks between the two quote marks delineating the text constant is that it confuses VB as to where the text constant begins and ends. So the programmers of VB devised a scheme to get around this problem... to include a single quote mark inside a text constant, you simply double up the quote marks... that is, wherever you want a single quote mark, just type two of them next to each other at that location.

 

[Marcelo Branco]

VB uses quote marks to delineate text constants... anything between a set of quote marks are a text constant (that is, a collection of text characters). The problem with putting one or more single quote marks between the two quote marks delineating the text constant is that it confuses VB as to where the text constant begins and ends. So the programmers of VB devised a scheme to get around this problem... to include a single quote mark inside a text constant, you simply double up the quote marks... that is, wherever you want a single quote mark, just type two of them next to each other at that location.

Rick,

Very good explanation.

M.

 

[dryper]

I see this as string within a string. Just curious, is it possible to nest more levels of strings? So I guess it's more levels of quotes?

Also, what's the difference between single and double quotes?