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

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

Jonathan Rynd

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.
 

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

This is a toughey guys. 1
Excel Formula question 0
Making part of a formula a variable 2
How do I put a blank value in a cell not using "" in a formula 2
Referencing another workbook using a variable for the sheet? 20
How do I do this? 3
How to Control a formula by a character in adjacent column on same 4
Can a formula do this? 1

Top