I have been using the Wrox Excel VBA 200 book.

When I create a user defined function for use in Excel Workbook (ie typing
the function directly into the cell), I get an error message name #Name? when
I enter the function into a cell.

This happens even when I am copying examples directrly from the book.

Clearly I am doing something wrong but what is it