Here's how:

1. Open the Visual Basic Editor (from Tools menu, select Macro, the
Visual Basic Editor).
2. Hit Ctrl-R to make sure the Project Explorer window opens (it shoul
already be open). This is a window which should show the open workboo
names and the sheet names in the workbooks in tree form.
3. Right-click on the workbook you want the function in and selec
Insert -- Module.
4. Paste the code you have there.

Note that the function will only be available when the workbook is ope
(i.e. you cannot use it in another workbook). If you need to use it i
another workbook, you would put the code in your personal macr
workbook (I'll explain if you need).



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26683