BR,

You can use

MyVal = Application.worksheetfuntion.percentile(Array, 0.99)

within VBA, without writing the array to the sheet.

HTH,
Bernie
MS Excel MVP


"BHARATH RAJAMANI" wrote in message
...
Hi

I have 5mio currency values in an unsorted VBA array. I need to find the
99.99th percentile highest value without writing the array to a spreadsheet
and using the worksheetfuntion.percentile

Any ideas? TIA!!

Rgds,
BR

--
Capital Markets
GE Capital, London