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

  • Thread starter Thread starter EPIGONO75
  • Start date Start date
E

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.
 
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"")"
 
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!.
 
Back
Top