#VALUE! error with custom excel vba function
Thanks for the advice.
This is what I thought as well, but even if I set the inside of the function
to this only line:
GetSmokePower = 3
I get the same error...
Any idea?
Thanks by advance,
Martin
"Dave Peterson" wrote:
I'd guess that there was something wrong in the code you didn't share.
Martin J. wrote:
Hi everybody,
I get a #VALUE! error when using a custom function. Here is the code of the
function (in a VBA module):
Function GetSmokePower(PlantType As Integer, FuelType As Integer)
...
...
GetSmokePower = Vswe
End Function
I just call this function that way in excel:
=GetSmokePower(3,1)
Did I do something wrong? Do I have to set some options on or off?
Thanks a lot for helping me,
Regards,
Martin J.
--
Dave Peterson
|