Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Some expert help is required on this one. I want to
create a VBA function that calculates the derivative of another function between two points. The syntax would be something like the following: Gradient = DerFun(Height(), x1, x2) where Function DerFun(Arg_Function as function, point1, point2) DerFun=(Arg_Function(point2)-ArgFunction(point1))/ _ (point2-point1) End Function What is the proper syntax, instead of "Arg_Function as Function"? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Passing a UDF as an argument to a UDF | Excel Discussion (Misc queries) | |||
Passing range as argument | Excel Programming | |||
Passing an Array of User-Defined Type to an Argument of a Function | Excel Programming | |||
passing a variable as an argument to a function | Excel Programming |