Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NOVICE :!! PLS help calling function!!!!
I really dont understand why I cannot pass the vector rstar in the function
forward...it gives me #value!!!!!!!!!! The input of the function forward is a vector of the same dimension of rstar!!!!!!!!!!!!!!!!!!!!!!!!!!!! Option Base 1 Function swap(r As Variant, date_pay As Variant) Dim fw() As Variant Dim rstar() As Variant n = date_pay.Rows.Count ReDim rstar(n, 2) ReDim fw(n, 1) rstar = interpolated_yield_curve(r, date_pay) fw = forward(rstar) swap=fw If I use just:: fw = forward(r) swap=fw OR rstar=interpolated_yield_curve(r, date_pay) swap=rstar it works sigularly so the function are right, but i can pass the input of the first in the other.! why?? thank a lot! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling a function in my SQL-DB from VBA | Excel Discussion (Misc queries) | |||
Calling function from a userform | Excel Discussion (Misc queries) | |||
Calling a function and then returning | Excel Discussion (Misc queries) | |||
calling a function | Excel Programming | |||
Calling a function from within EXCEL | Excel Programming |