Insert average, minimun, and maximum values in workbook

I wish to insert some key parameters such as average, minimum, and maximum values of a range G (column G) in the same ACTIVE workbook as follows. The number of rows in G may differ from file to file. All files have only one sheet, so we are concerned with the active worksheet only.

Cell J30 Put maximum value
Cell K30 Put cell address of max value
Cell L30 Put Roundup of max value (roundup to nearest 10's)


Cell J31 Put minimum value
Cell K31 Put cell address of min value
Cell L31 Put Rounddown of min value (rounddown to nearest EVEN whole number)

Cell J32 Put average value

Additionally, I would like the cell addresss of minimum. maximum, and average values to be highlighted in different colors.

Any help to devise such a MACRO would be welcome.

Thank you StevenM for your kind reply and code. Unfortunately, sometimes the code runs ok while sometimes it shows
Runtime error 1004
Method 'Rows' of object '_Global' failed

Secondly, I want the actual cell addresses of Maximum and Minimum values highlighted in the G column and not the cells K30 and K31. Sorry, my explanation was not quite clear on this.

Kindly look up and thanks once again for your prompt reply.

Hi StevenM:
I figured out why sometimes the code was not working. It was because the active sheet had a chart selected. When I deselected the chart, the code worked fine. Now just one request. Look at the second part of my querry, regarding highlighting the actual cell addresses in the column G.

Thanks!

Change the last two lines to:

Please Login or Register  to view this content.

Thanks StevenM.