Thread: #VALUE! error with custom excel vba function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Martin J.[_2_] Martin J.[_2_] is offline
external usenet poster
  
Posts: 4
Default #VALUE! error with custom excel vba function
No idea?

"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.
Reply With QuoteReply With Quote