Find the lowest integer in an array

[publius190]

I have an array of integers and i want to test for the smallest value in sections of the array. In other words if i have an array:

value(14) As Integer, r As Integer

'Code that sets array values

r = int (5 * rnd)

'find the lowest between:

value(r * 3 - 3) and value(r * 3)

'lowest value(n)

'return n


I already have the code to set the array values. I just need to find the array member with the lowest integer, not the integer itself.

Thanks in advance. Sorry if this is kind of a strange one!

[Leith Ross]

Hello publius190,

This example should help. You can use either a Range or an Array, It will return the index number that holds the minimum value.

Please Login or Register  to view this content.

[publius190]

So doing it with ranges will find the lowest range in the array? like the smallest amount of cells?

[MarvinP]

Hi publius190,

I thought about this problem yesterday and realized there are lots of kinds of arrays. There are single dimension and double dimension arrays. Arrays can be horizontal or vertical, when looking at them in Excel. If you were to know the 7th position in an array contained the smallest value this wouldn't be enough. You'd also need to know where the array started and/or ended. How about the (3,4) position in the array? All this can be done with VBA but I'm clueless on how you need to apply this information. See the attached for some more questions about your thread.

[Leith Ross]

Hello publius190,

A range is a 2-D array. The macro will return the lowest number found within the range the same as it will with a declared array. Here is the macro rewritten to examine a range for the lowest value and return the row of the cell.

Please Login or Register  to view this content.

[publius190]

OK thanks everyone. Finding the range with the minimum value worked perfectly.