I would like a formula or VBA that will record the highest value of a cell. For example I need B1 to show the highest recorded value of A1.