MrExcel Publishing
Your One Stop for Excel Tips & Solutions

User-Defined Functions

Posted by Chris on September 09, 2000 7:50 PM

I have written a function that is error-free only when the arguments reference ranges in the active worksheet. For example, when I insert a range from another workbook, I receive "#VALUE". Any suggestions???

Posted by Celia on September 09, 0100 9:22 PM

There is probably something in your code that is not referenced properly for calling from another workbook.