How can I use SetLinkOnData in excel to run a macro when a cell changes value from external link?
I have a list of stocks from cell A9 to A50. I'm using dde links to get my data. I would like to run a macro whenever one of the cells changes value. SetLinkOnData seems the only way to do this. The values are in column B.