How to keep track of high and low values for multiple cells in a sheet

Hallo there, I came upon VB code that will track the high and low associated with a specific cell in a worksheet. The code is:
***

Please Login or Register  to view this content.

***

I don't know how to apply this code to multiple cells in a sheet.

Example:
Row 1 - Value 1
Row 2 - Value 2
Row 3 - Value 3

I want to keep track of the highs and lows for Value 1, Value 2 and Value 3 in a single sheet.

Please help me.

Hi Attienel,

Below is some code that finds the lowest and highest values in the first 3 rows of a sheet and reports the values for each. I have attached the spreadsheet as well. The macro is set to run automatically anytime a number is entered into any of the cells in the first 3 rows, so you can try it out and see if has the basics of what you are looking for.

Please Login or Register  to view this content.

Hope that helps,

Daniel