how to count total #s

What do you mean by 'Live' ??
Is that a formula? Can you show that formula?

If A1 is changing via a formula, it's going to get very difficult.
We do have a Worksheet_Calculate event code, that is similar to the Change event code.
Change is triggered by manually changing cell values
Calculate is triggered when a sheet is calculated for whatever reason.

This gets tricky because there is not method I know of to know 'Which' formula changed it's value.
So you'd have code that is changing the value of A2 everytime ANYTHING on the sheet recalculated, not necessarily just A1.

Oh 'Live' is data from yahoo Finance. Is there a way to spread all live data in a cell into the spreadsheet? I need all data to create a chart or do a calculation as I mentioned above. Thanks~

I'm sorry, but that is very vague. You assume we all know how 'yahoo finance' works.

How 'exactly' does the value in A1 change ?
Did yahoo finance put a formula in A1 ?
Do you have to run a Query that updates A1 ?
Is there a macro you run that updates A1 ?

Just to show a little progress, here's how the calculate event code looks.

Please Login or Register  to view this content.

But again, this is not very good because it will run every time anything recalculates on the sheet.
If you have a formula in Say G25 or watever, and that formula changes it's value, but the formula in A1 did not, this will still run and add A1 to A2.
There is no method I know of to know 'which' formula changed it's value.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi the code is almost working for my purpose. Thank you :-)! One problem is when the A1.value changed to 1, I saw 1 was added to A2. But it didn't stop there and continued adding 1 in every second. Until A1.value changed to 0, it stopped. I want when A1=1, add 1 only once. How can I change the code? Thanks!