there are built in worksheet functions

rank
percentile
quartile
percentrank
max
min
large
small

see Excel help for details

--
Regards,
Tom Ogilvy

"Alex Lifeson" wrote in message
2...
In vba code, I need to go through several rows (with 75 cols each) and
pick
out the top 6 values PER ROW.

Are there any vba methods that would help me do this?

First, I thought I would sort and then pull of the first 6 cells. Can you
sort by Row? If not, should I transform the rows into cols and then sort
the cols?

Next, I have tried to find a Percentile / Rank or a Top N type function.

Any suggestions?

Thanks in advance!