ExcelBanter - DDE function with variables

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - DDE function with variables (https://www.excelbanter.com/excel-worksheet-functions/167938-dde-function-variables.html)

Toledo

DDE function with variables

I have the following DDE function that I would like to replace the word
'DESCRIPTION' with cell reference B1 and '.RUYXP' with cell reference C1

=TOS|DESCRIPTION!'.RUYXP'

I tried concatenate and &ing the fields but then I'm only able to create
text and not a real DDE function. Could someone let me know if there is a
way? Thanks in advance.

All times are GMT +1. The time now is 02:01 AM.