Put it in a standard module.

From the VBA window:

Insert Module

then paste the stuff in. Consider making the UDF Public.
--
Gary''s Student - gsnu200860


"cec34" wrote:

I'm an old-time programmer, but new to VBA in Excel 2007. I've written a
UDF, but so far, I haven't figured out how to test it in the Immediate window
(or the worksheet, for that matter). It compiles without error, but how do I
store it to make it accessible to the associated worksheet?