Can anyone point me in the right direction please?
You're right. Your special Worksheet_Calculate is needed if A2 has a
formula and its value changes as a result of another cell changing.
Worksheet_Change fires only
when its Target is changed manually, and earlier I assumed changing A2
manually.
Hth,
Merjet
|