Hi
not really sure what your trying to do but maybe the worksheet change
event will help. See
http://www.mcgimpsey.com/excel/accumulator.html

--
Regards
Frank Kabel
Frankfurt, Germany

"gi lee" schrieb im Newsbeitrag
...
Frank, Thanks for the tip but countif doesn't work because i am
outputing the "yes" result into the same cell. Therefore the cell
will
either say "yes" or will be blank for each of the runs and Countif
doesn't record/remember each trial.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!