max value in array problem

[Lochnagar]

Hi All,

Does anyone know if there is a bit of code when working with arrays that tells you the maximum value in an array (similar to Ubound), without having to loop through all of the values in the array until it finds the max value. I don't have a problem with looping through the array, but it just seems a little cumbersome.

Any help will be greatly appreciated.

Thanks,
Lochnagar

 

[VoG]

Maybe like this

amax = WorksheetFunction.Max(myarray)

 

[Lochnagar]

Hi VoG

Brilliant thanks - I hadn't even thought about the worksheet functions.

Lochnagar