Simple UDF help
Hi I have the following simple UDF. How can I reference
the column numbers (the column in which they reside on the
worksheet) of the arguments "first" and "last" from inside
the function?
Function CAGR(first As Double, last As Double, n As
Integer)
CAGR = (last / first) ^ (1 / n) - 1
End Function
Thanks.
|