Auto updating MAX function utilizing code?

[KC-Masterpiece]

Hello,


I have tried this suggestion (per another post) myself, and it seemed to be working OK for the first hour I had my sheet open. I then noticed that a variation of the following Sub would not update unless I clicked somewhere else in the sheet or edited another non-included cell. It's like something is holding up Excel from running this function and updating the cells if b2 is greater than a3 then a3 will not update to = b2 immediately.


Private Sub Worksheet_Change(ByVal Target As Range)
If [b2] > [a3] Then [a3] = [b2]
End Sub


My data in column B is formula derived and that formula contains data that is live updated data brought in from DDE link.


My question is, should I setup this formula as part of a macro, instead of workbook code and attach an Application.Ontime function to ensure reliable execution? Could too many IF statements cause delays (about 100 of them currently in the code Private Sub Worksheet_Change(ByVal Target As Range))?


Any help would be much appreciated.


Thank you!

 

[KC-Masterpiece]

Anybody have an idea for me? I'd really appreciate it.

-Tim