Hi,

I have some problem when using Worksheet_Calculate(), I want to write some
line to make cells change color when its value change after recalculate, I
use Worksheet_Calculate() but don't know how to locate the changed cells. For
Worksheet_Change(), we use Target.address to locate the changed cells
address, Do anyone know how to do the same thing with Worksheet_Calculate()?

Thanks alot.