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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - [EASY] I'll become mad ' & "" in variables (https://www.excelbanter.com/excel-programming/448893-%5Beasy%5D-ill-become-mad-variables.html)

[email protected]

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

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[_2_]

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

wrote:
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"")"

[email protected]

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

Il giorno lunedì 17 giugno 2013 10:36:06 UTC+2, 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!.

All times are GMT +1. The time now is 05:39 AM.