Thread: Simple UDF help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Salman[_2_] Salman[_2_] is offline
external usenet poster
 
Posts: 4
Default 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.