Discussion Starter · #1 ·
I have written numerous VB macros (subprograms) to facilitate operations in Excel. For months these macros ran without a hitch. Suddenly, I started getting this error message "Compile Error: Can't find project or library" when I try to execute some of these macros. When I click on the debug option it often points to a very simple assignment statement (often near the beginning of the macro) of the form: a=.... where a is previously undefined simple variable. My guess is there must be some simple switch or setting that I am unaware of and which got changed recently. Anyone know what the problem is and how to fix it?