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

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.
 
J

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?
Click to expand...

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

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.
Click to expand...

Thanks!.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
hope someone can help with excel save with 2003 and 2007 installed on my computer 9
VBA word change keys 0
Best Practice for Public Variables for Column Headings 2
Getting filename data 8
Drop down list control value in vba 2
Defining public/global variables in more than one place 1
Simple Variable to someone 5

Top