So, are you looking at changes in one particular cell or a range involving a
number of cells or even a number of different sheets.
In any case have a look at the Worksheet_Change event and that should allow
you to do this.

RBS

"morningstar333" wrote in message
...
I am getting stock quotes through Etrade Pro. Etrade Pro creates an excell
spread sheet that shows the bid and ask and last trade data updated every
1
second. I do calculations on the data provided and those calculated
number
change with the changes in the stock price. I want to track what numbers
the
calculations come up with and how often those numbers are repeated.

"ryguy7272" wrote:

Can you give more information please? There is usually a high
correlation
between the amount of information given and the quality of help given.

Thanks,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking
''Yes''.


"morningstar333" wrote:

I have streaming data coming into an excel spread sheet. I would like
to
count how many times each time a unique number displays and what that
number
is. Can anyone help?