My function used used to work :-( #name?

[actjfc]

Last week I developed a function in Excel 2007, it worked perfectly fine, this week I opened the workbook and is filled with #name? cells everywhere. Excel now does not recognize the function that was ok before saving it.

Does somebody has an idea what I am doing wrong? or what is it wrong with it?

Thanks!

 

[Trevor G]

Can you show the function code and where is it stored?

 

[actjfc]

It is something similar to this one:

Function FSA(ArrayX, ArrayY) As Double
Dim ArrayXVals(100), ArrayYVals(100)
Dim RS As Double

[some code…]

FSA = RS

End Function

I put it in Module1 and it worked fine before closing it. It is saved as .xlsm

Thanks!