A
a.riva@UCL
Hi guys!
An other question for you.
I would like to create a new UDF with VBA which could allow me to
determine the rank of a number within an array.
I know that Excel already has a function (WorksheetFunction.Rank())
that does that. But this function requires the second argument to be
declared as Range. Therefore I cannot use this function in the
context
of UDFs where I use array variables, because if I use an array as the
second argument I get a ByRef error. I do not want to assign my array
to a range on the worksheet, but I simply want to use my array as
reference for the ranking procedure.
How can I re-write the ranking procedure without using the Rank
built-
in function, so that I can use an array as reference?
Thank you very much!!!
Antonio.
An other question for you.
I would like to create a new UDF with VBA which could allow me to
determine the rank of a number within an array.
I know that Excel already has a function (WorksheetFunction.Rank())
that does that. But this function requires the second argument to be
declared as Range. Therefore I cannot use this function in the
context
of UDFs where I use array variables, because if I use an array as the
second argument I get a ByRef error. I do not want to assign my array
to a range on the worksheet, but I simply want to use my array as
reference for the ranking procedure.
How can I re-write the ranking procedure without using the Rank
built-
in function, so that I can use an array as reference?
Thank you very much!!!
Antonio.