View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Calculate event to do what Change event does.

Hi Howard,

Am Sun, 2 Aug 2015 04:55:33 -0700 (PDT) schrieb L. Howard:

The changes in column C are the result of formulas.

The Change Event works fine for changes entered in column C.

Not getting the Calculate to either 'see' the change/calculate or Evaluate the Countif when the formulas produce a duplicate in column C.


please post the formula in from column C


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional