I have written a custom function. One of its arguments is
a range. This function works fine when the referred range
is in the workbook that contains the custom function.
However, when this range is in an external workbook it
works ok so long as the external workbook is open. But
this external workbook is closed, the function returns an
error.

What do I need to do to overcome this problem?

Please help!

Deepak