I have a cell which is changing constantly. I need to detect when that specific cell changes. I know I can use Worksheet_Change event to detect that; the problem is that this event does not detect when the change is in a cell with a formula (or at least not that I know). This specific cell has a formula. So how can I capture that?
Thanks!