I have a function defined in a module, which I call in a worksheet. Each month my workbook gets updated with new monthly information.
The function works as intended, but if I notice some odd behavior when two workbooks are open in the same instance of Excel say, October.xls and November.xls.
The function works fine when I open October, but if I open November too, the function's values in October get overwritten with those from November, the opposite happens when I reverse the order of which is opened.
The function is declared private in both workbooks.
The function works as intended, but if I notice some odd behavior when two workbooks are open in the same instance of Excel say, October.xls and November.xls.
The function works fine when I open October, but if I open November too, the function's values in October get overwritten with those from November, the opposite happens when I reverse the order of which is opened.
The function is declared private in both workbooks.