Highest High using VBA if statement

[velocity1234]

I have a real time feed and I am trying to have excel automatically record the highest high.

I have the following Named Ranges:

HH = Highest High
Last = Last price (which is constantly moving higher and lower

I want the code to always be running in the background.

This is what I have, but I am over my head here.

If Worksheets("sheet1").Range("Last").Value >= Worksheets("sheet1").Range("HH").Value Then Worksheets("sheet1").Range("HH").Value = Worksheets("sheet1").Range("Last").Value

Any help would be greatly appreciated.

Thanks

 

[JoeMo]

What causes the values in your named ranges to change?

 

[velocity1234]

the last is a RTD feed into excel