excel UDF

[mustanggt89]

I have a UDF that I created to calculate golf handicaps. The problem is when ever I close the spread sheet and reopend it all the cells that contain the function have #VALUE! in the cell, I have to double click on the cell to get it to calculate. This happens all the time. I had the formula in a macro and it did the same thing. It used to take in 2 parms, but I've removed them and it still does the same thing. How can I get this to work. I've since put it into a Excel addin and have added it to my spreadsheets, but it still doesn't help. Thanks, for any help

[Ron Coderre]

Just a guess here.....

Do you need to include Application.Volatile in the UDF code to make it recalculate whenever the workbook calculates?

Ron