Hi,

Thanks. Sorry if I sound dim, but how do I insert functions into standard
modules rather than workbook or worksheet modules?

Jim


"Ron Rosenfeld" wrote:

On Mon, 3 Sep 2007 05:08:01 -0700, Creating Functions in Excel <Creating
Functions in wrote:

I am missing something fundamental in creating functions in Excel. Does
somebody have step by step, comprehensive instructions?

At this point, I somehow have a simple function that is recognized and
returns a 0 value, but does not appear in the VB Editor or in the list of
functions. Two other simple functions - same as the first with slightly
different names - appear in the list of functions and in the VB Editor, but
are not recognized when I insert the names into the corresponding spread
sheet.

Help would be appreciated,

Jim

Make sure your functions have unique names. (You can also use fully-qualified
names, but this is a PITA).

Make sure they are in a regular module, and not a workbook or worksheet module.
--ron