Question-user defined function

[ppyxl]

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

 

[Leith Ross]

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

 

[ppyxl]

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