VBA: Using & inside of an equation

Question

I want to make a formula with a & inside it but VBA thinks its a concatenate symbol

""&"" does not work, are there any other tricks?

Answer 1

How about just this:

dim s as string
s = "my_complicated_formula" & "&" & "and_another_formula"

Answer 2

s="foo" & Chr(38) & "bar"

Where chr(38) = &

Answer 3

...All_Models!$B$2:$B$" & nrow & ",""<=""&" & "Elasticity!A" & iRow & ")"