Hi, Yes I do have a follow up question...

i figured out how to make column A and Column B to repeat the above action.

However, the tricky thing is that with the event change function...this works brilliantly if someone is to put a new number into Cell A1...
but unfortunately if the data in Cell A1 is a formula, which generates a number, so its changing every second, the code does not do record it automatically.

I have been looking at the Event Calculate, perhaps thats the function i need or a combination of the two function event change and event calculate.

Alternatively....if i can get this code to do it every second or every other second to just make a record of the number in a certain cell - in this example its cell A1.

Is there anything similar like that?

Please advise, thanks.