Functions

[Eric Blitzer]

Office 2000

I have created function under This workbook thanks to JE
McGimpsey, Frank Kabel, and Harlan Grove(Ref Reverse
contents of cell May 12 1:20Pm). The workbook has been
saved, however I am unable to find this function in my
function list. How do I reference the function I just defined?

Thanks to all of you

Eric

 

[Frank Kabel]

Hi Eric
don't put the code unter the 'ThisWorkbook' module. Insert
a new 8standard module):
- right-click on the project name
- choose Insert - module

Now paste the code in this module.
After this you can invoke it as a worksheet function

 

[Eric Blitzer]

Thanks frank for you fast responses. Works great

Have a great day

Eric