Hi,
Why use a user function when you can simply DO:


CAGR= Application.WorksheetFunction.Rate(Count, 0, -(FirstValue), LastValue)

And sssign CAGR to wherever in your code:

e.g. Range("B3")=Format(CAGR,"00.00%")


"srinivasan" wrote:

Hi Toppers,

Thank you for your immediate response. Range is (First Value :Last
Value)which represents pv for present value and fv for future value of rate
function.
The correction to the code for right alignment with percentage symbol next
to the value may please be guided.