I struggle to understand why you are trying to do something in VBA that is blindingly easy in Excel - see attached
The automatic detecetion of whether a cell has changed, and if so whether it matters are the essence of Excel - why try and re-write it?
If you do not know Excel, then it is a thousand times easier to learn than VBA
|