I have got this file with various commodities and their LTP (Last Traded Price). The LTP is updated automatically with the help of an Add In provided by Bloomberg. I need to record the time of each change in LTP.
I have used the "Worksheet_Change(ByVal Target As Range)" option in VBA but this is not catching the change in the LTPs. The "Worksheet_Calculate()" is working, but I also need to know which LTP (among many) is changing. With the "Worksheet_Calculate()" option I can not identify it.
Any help is much appreciated.