Funny function problem with add-ins...
"Bura Tino" wrote in message
news:lRnhc.37737$yD1.111611@attbi_s54...
Hi,
I have an add-in which has worksheets in it, which are templates that I
copy
out. Now, I also have a function
Function stupid() As Double
stupid = 5
End Function
and one of the cells in the worksheet-to-be-copied-out says =stupid()
Unfortunately, when the spreadsheet is copied out of the add-in, that
cells
now says #NAME?. If I double-click into and press Enter, in goes back to
"5". Is there a way to avoid this problem?
Now just wondering if anyone else has had this problem...
Thanks,
Bura
|