Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
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.
Hi Ed,
you have to use, in the new worksheet, the reference (to the old worksheet) instruction :

