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

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

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