Can you record the highest value in one cell?

I have a worksheet that produces a current share price in the same cell. A1 for instance. The price is updated on a regular basis but always remains in the same cell and always shows the current price. Is there a function or a way of keeping a record of the highest value displayed in that cell?

I'm not sure if you can do it with a cell formula but you can use an object.

1. View--> Toolbars --> Visual Basic
2. Click the hammer and wrench icon
3. On the toolbar which appeared, left click the textbox icon (its got a little "ab" inside)
4. Left click and hold anywhere on the sheet and drag a box about 1 inch wide and tall. (a white box should appear)
5. on the new toolbar click the teal colored triangle to enter design mode
6. right click on the white square you created. left click "Properties"
7. to the right of the field named "LinkedCell" type "A1" (without the quotations)
8. to the right of the field named "Visible", change the value from "true" to "false"
9. close this little window.
10. Double left click on the white square
11. Where the cursor is blinking, paste this code.

Please Login or Register  to view this content.

Cells(1,2) means row 1, column 2. Change these numbers to whatever cell you want the highest value to be stored in. (don't make it cells(1,1))
12. Close the window where you copied the code.
13. click the teal triangle again to exit design mode.
14. Save

Hope that helps. I'm kind of asuming that you haven't worked with visual basic before. Oh yeah, cell A1 has to be a number or this won't work


Schwizer

Thanks for the response, this works great in a normal spreadsheet. It looks asthough the API that provides the data for me uses Visual Basic and when I activate it the figures don't update anymore. I'll contact the developers.

Thanks for your help though