#value error in simple VBA formula. Please help!

[cbeadles]

I'm receiving a #VALUE error when I attempt to run the following function on my worksheet. Specifically, I am told that "a value used in the formula is of the wrong data type"

both the ubeta unlever and relever fuctions that I call internally in this function run just fine on their own so I don't think the issue is with them.

Does anyone know what might be causing this error to occur? I've been staring at it for about an hour and can't seem to figure it out (bear with me I'm new)

Thanks

Chris

Function WACC(cbeta As Double, CDebtAsset As Double, ODebtAsset As Double, m As Double, rf As Double, CostOfDebt As Double, CorpTax As Double)
Dim ubeta As Double
Dim WACCbeta As Double
Dim re As Double

ubeta = Application.unlever(cbeta, CorpTax, CDebtAsset)
WACCbeta = Application.Relever(ubeta, CorpTax, ODebtAsset)
re = rf + WACCbeta * (m - rf)

WACC = ((1 - ODebtAsset) * re) + (ODebtAsset * CostOfDebt * (1 - CorpTax))

End Function

 

[Scott Huish]

I'm surprised you don't get "Object doesn't support this property or method"

What happens when you take off the Application. ??

 

[cbeadles]

I'm surprised you don't get "Object doesn't support this property or method"

What happens when you take off the Application. ??

When I take off the "Application." it still gives me the same error. After some research online I guess there isn't much difference between calling the function with/without it

 

[Scott Huish]

Can you post your code for your UDFs?

 

[cbeadles]

Can you post your code for your UDFs?

It actually just started working, It must have not refreshed properly after I deleted the "application."s Thanks so much for your help Scott

Chris