DDE formula links can only be literals, i.e., fully specified with no variable
components. You could use a macro to build up text strings that look the same as
the intended DDE links, then copy the formulas and paste-special as values on
top of themselves, then Edit > Replace replacing all = with =. I believe that's
the best you can do.
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.