RANK() Function - Passing Array to it in VBA

[origapizni]

The RANK() function Help says the REF argument can be an array. However, I can find no way to make it accept anything except a reference to a worksheet Range. For example, the ARRAY() function causes an error. Has anyone out there been able to make it work with anything other than a Range? TIA

From HELP:

RANK(number,ref,order)

Number is the number whose rank you want to find.

Ref is an array of, or a reference to, a list of numbers. Nonnumeric values in ref are ignored.

Order is a number specifying how to rank number.

 

[SkipVought]

Hi,

I believe that ARRAY here referrs to an array of formulas that you enter on a sheet using CTRL+SHIFT+ENTER, placint the ARRAY in brackets for evaluation.

Try performing this while macro recording and see what the VBA looks like.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com