Passing Quotation Marks (Eng/XL97/SR2)

[jstevens]

I would like to pass quotation marks (before/after) a variable and have encountered problems.

An Example:
Cell A1 contains the word Hello

Var1 = Range("A1").Value Var1 = Hello

Var2= ??? this is the problem Var2 should = "Hello" (notice the quote marks before/after Hello)


It is the simple things in life that give us problems.

[LegareColeman]

Try:

<pre> Var2 = """Hello"""
</pre>

[jstevens]

I guess I should have made a notation that Var2 = Var1 and the final results should read as: "Hello"

[jstevens]

Its the simple things....

The solution is: Var2 = """" & Var1 & """"