Hi,
I have an excel sheet which fetches stock price data in two cells, namely "LAST TRADED TIME" and "LAST TRADED PRICE". These two cells are getting populated from an external source using RTD functions and are constantly changing. I have created Worksheet_Change targeted on "LAST TRADED TIME" and copying these two cells in another place on the same worksheet using a macro. The problem is that even though these two cells are changing, the macro code is not being called. When I press F2 key and ENTER on the "LAST TRADED TIME" cell, the macro is called and contents are copied on desired location. Is there is any workaround where I do not have to interfere in the sheet since the frequency of change is reasonably high. Thnx
I have an excel sheet which fetches stock price data in two cells, namely "LAST TRADED TIME" and "LAST TRADED PRICE". These two cells are getting populated from an external source using RTD functions and are constantly changing. I have created Worksheet_Change targeted on "LAST TRADED TIME" and copying these two cells in another place on the same worksheet using a macro. The problem is that even though these two cells are changing, the macro code is not being called. When I press F2 key and ENTER on the "LAST TRADED TIME" cell, the macro is called and contents are copied on desired location. Is there is any workaround where I do not have to interfere in the sheet since the frequency of change is reasonably high. Thnx