Hi, I am currently using the following code, however I want this code
to work continously when ever the numbers in row 1 change (these
numbers change autimatically as they are a live feed referenced from
another program). How can I make this continous?
Sub Bid_Offer_Tracker()
'****Highest Bid Price****
If Range("a2").Value < Range("a1").Value Then
Range("a2").Value = Range("a1").Value
End If
'****Lowest Offer Price****
If Range("b2").Value > Range("b1").Value Then
Range("b2").Value = Range("b1").Value
End If
'*****Lowest and highest LTP*****
If Range("c2").Value < Range("c1").Value Then
Range("c2").Value = Range("c1").Value
End If
If Range("c3").Value > Range("c1").Value Then
Range("c3").Value = Range("c1").Value
End If
End Sub
thanks
Sacha David
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
