View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] EPIGONO75@yahoo.it is offline
external usenet poster
 
Posts: 6
Default [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.