OldSwimmer1650
New Member
- Joined
- Dec 3, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Worksheet_Calculate functions when the worksheet is recalculated.
Worksheet_Change functions when a cell is updated, but not when the cell changes due to a recalculation. For example if cell A4 is the sum of A1:A3 and I change A2 so cell A4 value changes this will not trigger Worksheet_Change.
I'm looking for a function that detects when a cell changes values due to the formula.
Worksheet_Change functions when a cell is updated, but not when the cell changes due to a recalculation. For example if cell A4 is the sum of A1:A3 and I change A2 so cell A4 value changes this will not trigger Worksheet_Change.
I'm looking for a function that detects when a cell changes values due to the formula.