And just to add to Dana's response...

You may want to keep the code in your personal.xls workbook. Then you'll be
able to use this function in any workbook you open (follow Dana's syntax,
though).

But if you share the workbook with this formula in it, it could get messy. (I'd
convert the formulas to values before I share.)

Dana DeLouis wrote:

... So I deleted it from personal.xls and pasted it
into my real workbook and it seems to be working.

Hi. Glad it's working :) Just some added info. Since you placed that
function into another workbook, and that workbook was not an Add-Inn, then
you need to point to the workbook that has that function. For example, I
believe the following would have worked in your case.

=PERSONAL.XLS!LastGroupOfNumbers(A1)

A good technique is to have Excel enter the function for you. This helps as
a check also when writing new functions.
On the worksheet, chick the "Insert Function button next to the formula bar
(Fx)
Select the "User Defined" category.
Now, look for your function. This will enter the complete reference.
If you don't find your function, then it may be a clue that the function was
placed incorrectly on a worksheet module, so something similar.
HTH. :)
--
Dana DeLouis
Win XP & Office 2003

"Mr. Me" wrote in message
om...
On Tue, 02 Aug 2005 08:17:46 -0500 in article <42EF727A.46BC3CA2
@verizonXSPAM.net, spoke thusly...
I just copied Dana's code and pasted into a General module (not behind a
worksheet and not behind ThisWorkbook). Then I added that reference and
it
worked fine for me.

Did you put it in a General module?


I don't know. But when I hit alt-F11 it opened a VBA window, which
happened
to be in personal.xls, which holds all my global macros. I don't know why
it
opened personal.xls since my real worksheet had the focus at the time. So
the
first time I pasted it there. So I deleted it from personal.xls and pasted
it
into my real workbook and it seems to be working.

Thanks.

--
Sig: Say no to fixed width HTML tables. They look terrible in most
browsers.

--

Dave Peterson