DDE formula with variable

B

Bruce

I have a DDE formula which I wish to make the part "bhp" a variable in cell
A1. The working formula is as follows

=pulsesecurity|bhp!code

I have tried to replace with the following but I get errors

=concatenate(pulsesecurity|,A1,!code)

=concatenate("pulsesecurity|",A1,"!code")

What are some possible solutions?

Bruce
 

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

Excel - Wich Function should I use? 1
Problem with SET & REF function 0
VBA word change keys 0
Concatenate cells with line breaks in them 4
Evaluating a DDE formula created by strings 2
DDE function with variables 0
Median Formula not working properly 2
Conditional concatenating!!! 3

Top