Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question-user defined function
Hi, I got a function like this: ___________________________________ Function SumString(ByVal str1 As String, ByVal datef As Date) SumString = str1 + Str(datef) End Function ___________________________________ It works fine yesterday. I can directly use in my excel sheet lik other function. But today, the cell only gives me #NAME? why? and how can i activate this function again? Thanks -- ppyx ----------------------------------------------------------------------- ppyxl's Profile: http://www.excelforum.com/member.php...fo&userid=3611 View this thread: http://www.excelforum.com/showthread.php?threadid=56017 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question-user defined function
Hello ppyxl My guess is that your macro was written on one of your Worksheets. I so you need to add a Module to your Workbook and place your macr there Sincerely Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=56017 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question-user defined function
Ross, Thanks for reply. I did copy to the workbook that I am using. Straight thing is now I reopen, the function works again. I want t know whether there is some problem within. ppyx -- ppyx ----------------------------------------------------------------------- ppyxl's Profile: http://www.excelforum.com/member.php...fo&userid=3611 View this thread: http://www.excelforum.com/showthread.php?threadid=56017 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined function - Help | Excel Worksheet Functions | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
A Question on User Defined Functions. | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |