Counting how many times a cell changes per minute

[Bravo1]

Hello
I have a number of different cell ranges in a worksheet that are each being continuously updated via a DDE link.
I need to know separately how many times each cell (or range of cells) has changed over the past minute, on a continuous basis (rather than step-wise from one minute to the next).
Can someone please suggest some code to do this?
Thanks in advance.

 

[bensonsearch]

something similar to this but modified how you please (bigger range and counting integer somewhere on the sheet), this goes under sheet1 in vba editor not module.


Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range

' The variable KeyCells contains the cells that will
' cause an alert when they are changed.
Set KeyCells = Range("A1")

If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then
' Display a message when one of the designated cells has been
' changed.
' Place your code here.


End If

 

[Bravo1]

Thanks very much for the starter Benson.
I sure the worksheet_change event procedure will work - I'm still trying to play around with this at the moment.
The main problem I'm having though is coming up with a counting technique that will work to capture the number of changes for the past minute only. Any suggestions?

 

[bensonsearch]

if its ONLY for a specified time maybe try using something like

dim asd as variant
dim dsa as variant
 
dsa = now()
asd = now()
 
do until asd = dsa + TimeValue("00:01:00")
 
'all code here
 
asd = now()
loop

this will need tweaking but should work fine