dolphintabby
Member
I got this formula somewhere and it works fine on 1 file. I just tried to add it to another file and it returns #NAME? error. Now I can't find anything on this formula.
Regards,
~Dee
Regards,
~Dee
=SavedDate()
- Thread starter dolphintabby
- Start date
NARAYANK991
Excel Ninja
Hi ,
My guess would be that SavedDate is a UDF ; the file in which it works has the associated VBA code ; the file in which it does not work does not have the associated code.
In general Excel gives the #NAME? error when it cannot find the reference made in the formula ; this can be because a standard Excel function has been mis-spelled , as in CHR instead of CHAR. It can be because a named range has been used within a formula but has not been created / defined.
Narayan
My guess would be that SavedDate is a UDF ; the file in which it works has the associated VBA code ; the file in which it does not work does not have the associated code.
In general Excel gives the #NAME? error when it cannot find the reference made in the formula ; this can be because a standard Excel function has been mis-spelled , as in CHR instead of CHAR. It can be because a named range has been used within a formula but has not been created / defined.
Narayan
dolphintabby
Member
Thank you. You were right. 