Help Please! - Saving a UDF as an Add-In Results in error 91

[rawzko]

Please help.

I am trying to make UDFs and save as an add-in. When Excel trys to open the add-in I get:

Run-time error '91' Object variable or With block variable not set

Here is the code I am using in VBA:

Function trythis(enterthis As Double) As Double
trythis = enterthis +1
End Function

Not sure what is wrong. It seems like I'm not declareing properly.

Thanks in advance

 

[kpark91]

Try putting "Public" in front of Function?

 

[rawzko]

Tried that with no luck yet. Any other ideas? Could it be something worng with my registry?

 

[rawzko]

Bump. Anyone have any ideas?