Excel returns @name? error when using a custom written function in

I am new to Macros and VBA.

I have written a function in VBA and it returns a #Name? error when I use it
in the spreadsheet. I then tried a very simple function and that did exactly
the same so I believe I dont have a syntax error.

What am I dong wrong?

Al

Are you putting the function in a regular code module, rather than in a
worksheet or ThisWorkbook module?

See http://www.mcgimpsey.com/excel/modules.html



In article <[email protected]>,
Al Maher <ddd4(pnospam)@hotmail.co.uk> wrote:

> I am new to Macros and VBA.
>
> I have written a function in VBA and it returns a #Name? error when I use it
> in the spreadsheet. I then tried a very simple function and that did exactly
> the same so I believe I dont have a syntax error.
>
> What am I dong wrong?
>
> Al

You need to put UDFs in a standard code module, not a sheet module, or
ThisWorkbook.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Al Maher" <ddd4(pnospam)@hotmail.co.uk> wrote in message
news:[email protected]...
> I am new to Macros and VBA.
>
> I have written a function in VBA and it returns a #Name? error when I use
it
> in the spreadsheet. I then tried a very simple function and that did
exactly
> the same so I believe I dont have a syntax error.
>
> What am I dong wrong?
>
> Al