#VALUE! error from UDF

I have this user defined function that takes two inputs (temp and relative humidity) and gives one output (enthalpy). I have created the code in a macro-enabled workbook, checked all the functions within the spreadsheet, and then saved as an add-in. When I open the add-in in another workbook, all the other UDFs work except one. This function returns a #VALUE! error, although the correct data type is selected. When I try it in the original workbook, it starts with the error, I open VBA and save the code and ppof, it works without me changing anything. Below is the code and any help is always greatly appreciated.

Please Login or Register  to view this content.

this does not look like a udf. it looks more lika a macro
I am giging you a trivial example of udf
udf will be dealing with variable
using UDF you can gets the result either as a macro or formula in worksheet.
see attached file "phillip 130803"
the UDF is in the module

in spreadsheet if you type the formla as in c10 you will get 15

if you run the macro test from the module then also msgbox will give 15

now you can understand what is a UDF and how to use it. now you can rewrite UDF and macro or formula

if there is problem or doubt post back to the newsgroup

@Venkat - UDF simply means User Defined Function.

Philip's code is a Function, not a Sub, so by definition it is a UDF.