If I write a function as a program in one document is there a way to use it in another document without re writing it?
Aside from copy and paste?
You can reference one document in another "insert Reference." It effectively inserts the WHOLE DOCUMENT at the point of reference.
you have to use, in the new worksheet, the reference (to the old worksheet) instruction :