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