Hi,
From within my workbook I create a new workbook with calculations. Since Excel does not have a function to do what I want, I created my own function. This function is called from the new workbook, which is a problem when the original is closed or not available or as I have found even when it is changed.
Is there a way to copy a function (or the code for the function or an entire module) to a module in the new workbook so that it can be adressed rather that the function in the old workbook
Luke
From within my workbook I create a new workbook with calculations. Since Excel does not have a function to do what I want, I created my own function. This function is called from the new workbook, which is a problem when the original is closed or not available or as I have found even when it is changed.
Is there a way to copy a function (or the code for the function or an entire module) to a module in the new workbook so that it can be adressed rather that the function in the old workbook
Luke