Hi all,
I'm trying to target individual cells whose value has been updated / changed after every Calculate event.
The worksheet I'm working on is pulling live data from an external source (updates almost every second), and I'm hoping to highlight each cell that has changed with a color code (representing which band it falls in) each time a Worksheet_Calculate() event takes place but I'm not sure how.
I just want the changed cell to flash once, which I know how using the OnTime method. I just don't know how to determine/trace which cells have changed. *Comparing with previous values cell-by-cell is NOT feasible as the data is too extensive.
Any solutions?
Thanks in advance.