How do I make 'CSCO" in this formula a variable? =ilx|Q!'CSCO,open

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
G

Gary Thomson

Hi,

adjust this to

="ilx|Q!'"&A1&",open"

Now type CSCO into cell A1 - this will do what you
currently want it to do.

All you need to do now is type whatever you want in cell
A1 and the formula will change as a result

i.e. if you type CMC in cell A1, then the formula would
effectively become:

=ilx|Q!'CMC,open


Incidentally, what exactly are you trying to do???

Happy to Help,

Gary Thomson.
 
adjust this to

="ilx|Q!'"&A1&",open"
Click to expand...

Won't work. The | means "Open a DDE link using the addin whose name is
specified before the |, with the parameters after the |."

A string containing a | does not cause the DDE to happen.
 
Back
Top