Funny function problem with add-ins...
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? Thanks, Bura |
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 |
All times are GMT +1. The time now is 08:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com