Minimum value of last row in several coloumns

[RorschachDK]

Hello

My problem is - Im trying to find the minimum value of the last row of a series of coloumnsin different sheets. The min value I then want to display in a certain cell. My Code is:

Please Login or Register  to view this content.

I canīt figure out how to wright my range. It should be noted that the columns I need do not stand next to eachother..it varies

Best regards

[Richard Buttrey]

Please upload your workbook and manually add the result you expect to see. Tell us which cell contains the result and how you calculated it. It's always easier to see these questions in the context of their workbook.

[RorschachDK]

Sry-forgot to attach

In the sheet "production data" when you use to macro store, it takes the values you have typed in and stores them in the sheets: front, middle and back. Now I have added another sheet called Overview where different things such as min and max values and mean shall be calculated. fx. the min value of all the densities for a certain board nr i want to calculate. The requires me to take the last row of the coloumns 7,9,11..and so on in the sheets front middle and back but how do i do that.