Hi All,

Iam new to Vba coding .I have a foumul
=PERCENTRANK(CategoryLookup!$F$10:$G$10,D4,3) In this formula the firs
parameter ie "CategoryLookup!$F$10:$G$10 " is a range that is to b
dynamcally generated based on some
lookup values.So i tried wriiting a User Defined Fuction(UDF) returnin
that range based on some logic.But it's not working .What can be th
problem.Is it possible to substitute a range parameter in a workshee
function using a UDF returning range.Can anybody help me on this

Thanks in advance
Xcelio

--
xcelio
-----------------------------------------------------------------------
xcelion's Profile: http://www.excelforum.com/member.php...fo&userid=1628
View this thread: http://www.excelforum.com/showthread.php?threadid=31373