I tried the code that was posted on VBA code that was posted back way back on page1. The purpose was to build a DDE code that referenced other cells. It only particially works for me.
When I typed TOSDDE("AAPL","BID"), a dynamic number was return. However when I replace the code with...