Hello James

Maxvalue = Application.WorksheetFunction.Max(myarray)

will do the trick.


--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"JAmes L" skrev i en meddelelse
...
Hello,

I have a an array called myarray(50) in vba

I am feeding numbers from a table into the array through a loop. How do i
then get the highest number out of the array?

Thanks in advance,
James