VBA Rank

[ehcpieterse]

Hi there,

I am having trouble with:
Ranking = Application.WorksheetFunction.Rank(Window(100), Window, 0)

Where Window is an array containing 100 values. I am trying to determine the rank of the last value in the array.

Thanks

 

[stanleydgromjr]

ehcpieterse,

"Window" is a VBA Class. I am not sure I am explaing this correctly.

You may want to try changing "Window" to something else.


Have a great day,
Stan

 

[ehcpieterse]

Hi,

I have changed it to:
Ranking = Application.WorksheetFunction.Rank(RankRange(100), RankRange, 0)

I am still getting "Object required". Does this function only want a range input instead of an array?

 

[stanleydgromjr]

ehcpieterse,

Excel Help:

RANK
Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)

Does this function only want a range input instead of an array?

It would appear so.


See Aladin Akyurek's response to:
http://www.mrexcel.com/forum/showthread.php?t=82479


Have a great day,
Stan