View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default 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