I don't think that you can. The Calculation engine is all under the hood,
Excel uses a smart calculation model, that is it determines what cells need
recalculating but I don't believe that it exposes that data.

--
__________________________________
HTH

Bob

"SaltyBall" wrote in message
...
Hi,

Worksheet_Calculate(), I want to make cells change color when its value
change after recalculate.

Worksheet_Change() can use "Target.address" to locate the changed cells

How to find affected cells for Worksheet_Calculate()?
Worksheet_Calculate() have no "Target.address"


Thank you.