Thank you Jim
Thank you Tom

Tom Ogilvy wrote:
http://support.microsoft.com/kb/170787/en-us
Description of limitations of custom functions in Excel

See the 5th bullet.

http://www.cpearson.com/excel/hidden.htm
Hidden namespace

--
Regards,
Tom Ogilvy



"chillihawk" wrote in message
oups.com...
Hello Everyone,

I want to write a UDF which amoungst other things adds a couple of
names to the Workbook.Names collection, it then tee's up a Sub which
uses the values I've just stored in the names. So I have a couple of
questions:

1. Am I correct in saying that this is not 'ordinarily' possible from a
worksheet function (i.e.

public function someTest(ByVal l_dbIn as double) as double
Thisworkbook.names.add "aName", l_dbIn
someTest = l_dbIn + 1
end function

=someTest(20)

does not work). I've tested it and it doesn't but if someone could
confirm I'd be grateful.

2. I vaguely remember reading, possibly in a post by Laurent Longre,
that it could be done by adding an XL4 name. Is this correct? If so
how would it be done (syntax etc.)? What are the implications (ie do I
need to add an XLM Macro sheet, how do I do this)?

I need 6 names and I will be storing: a long, 4 strings and a date

I appreciate there are other ways to do this, writing to a file etc.,
but I'd like to give this a go if its feasible.

Thanks everyone,

chilli