I am working on a "lesson" to help users understand how certain practices can unnecessarily flag Excel cells for calculation.
I am aware that the Dirty
method can be used to flag a cell for calculation in VBA. Is there a way to determine whether a particular cell is flagged for calculation (in VBA)?
I want to be able to loop through cells in a sheet and highlight that cells, which need recalculation. I want users to be able to visually check how many dirty cells were created due to an action.