Hi Bill,

I have put the info in module 1 and the formula in sheet but still it says
the same.

Regards

Ahmad

Bill Manville wrote:
Takhan via OfficeKB.com wrote:
I have done the VB function and then copied the formula you told me and in
cell it says #NAME?

Then you can't have done it right<g
It worked fine for me.

With the workbook open, Alt+F11 to the VB editor, in Project Explorer,
expand the project for your workbook (make sure it is not a different
workbook's project), double-click Module1 and check that the function is
indeed present there. If you don't have a Module1 then you didn't put it in
the right place.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200806/1