[EASY] I'll become mad ' & "" in variables

[EPIGONO75]

Simple line:

Cells(1, 1) = "=IF('[1.xlsx]variable'!A1='[2.xlsx]variable'!A1,""ok"",""no"")"

How can I substitute the "variable" text with a real variable?.
The simple &variable& doesn't work...

Thanks in advance.

 

[joeu2004]

Simple line:
Cells(1, 1) =
"=IF('[1.xlsx]variable'!A1='[2.xlsx]variable'!A1,""ok"",""no"")"
How can I substitute the "variable" text with a real variable?

Cells(1, 1) = _
"=IF('[1.xlsx]" & variable & "'!A1='[2.xlsx]" & variable & _
"'!A1,""ok"",""no"")"

 

[EPIGONO75]

Il giorno lunedì 17 giugno 2013 10:36:06 UTC+2, (e-mail address removed) ha scritto:

Simple line: Cells(1, 1) = "=IF('[1.xlsx]variable'!A1='[2.xlsx]variable'!A1,""ok"",""no"")" How can I substitute the "variable" text with a real variable?. The simple &variable& doesn't work... Thanks in advance.

Thanks!.