Excel Function Argument

[bloubul]

How do one add a new argument into excel functions.

I want to use the following formula, =LastNPostion(G$10:G$15,-3), but in order to use it I must add LastNPosition into excel, how must I go about

Any one please.

BlouBul

 

[time*treat]

In the VB editor, insert a new module, then ...

Option Explicit
Function LastNPostion(byVal variable1, byVal variable2, byVal variable3, ... )
...
... code goes here to ...
... calculate LnP_result
...
LastNPostion = LnP_result
End Function

"Option Explicit" & "byVal" are optional.

 

[bloubul]

Thanks time*treat

It works like a charm

BlouBul