frens said:
Hello Beban
a nice job! That's what I wanted.
How do I
a. include your functions in an existing excel file?
b. add my own functions
best,
Frens
Thanks. Once you've downloaded the file from the web site, you can just
copy and paste the whole module into a general module in the existing
file if that's really where you want them. It might be more useful to
save the file as an add-in, and in any file in which you want to use the
functions go to the VBE, click Tools, References, and check off the file
name to make them available in that file. Or you could consider pasting
them into your Personal.xls file if you think you might have general use
for them; that way they would be available to any open Excel file.
As for adding your own functions, they can simply be written (or pasted)
into the module, or into any general module in the file, wherever you
keep it. The file is simply an Excel Workbook with a single worksheet
for the procedure descriptions and a single general module for the
procedures.
Regards,
Alan Beban
