Highest Lowest price from running price

dhanu1660 

Start by entering -1000000 in M10 and 1000000 in M12. These are initial values that will be overwritten.

Enter the formula =NOW() in another cell (it doesn't matter where).

Right-click the sheet tab.

Select 'View Code' from the context menu.

Copy the following code into the worksheet module:

Private Sub Worksheet_Calculate()
    Application.EnableEvents = False
    Range("M10").Value = Application.Max(Range("L9,M10"))
    Range("M12").Value = Application.Min(Range("L9,M12"))
    Application.EnableEvents = True
End Sub

Switch back to Excel.

Save the workbook as a macro-enabled workbook.

Make sure that you allow macros when you open it.