Calling Procedures from another excel sheet by passing objects
 

Hi,
I like to keep all my general purpose procedures/functions in a
seperate excel sheets as series of modules to maintain them at a
single location. How can I call them from another working sheet
without importing the applicable module. The Application.run does not
allow me to pass objects per HELP.

Help screen says "Objects passed as arguments to the macro are
converted to values (by applying the Value property to the object).
This means that you cannot pass objects to macros by using the Run
method"

Thanks