MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VBA Bug??


Posted by SunRise on February 15, 2002 7:32 AM

Hi,

I have the option "Require declaration of variables" off, but it seems like it is still complaining that project or library is not found. I'm on Excel XP on Win2000. Is this a bug??

Second, my VBA on existing workbook is complaining that project/library is not found for the built-in functions like "Trim$()" or "Left$()", but it works fine when I use that function on the new workbook. It sounds like there is some setting on my existing workbook that is preventing VBA from recognizing these normal functions.


Any ideas?


Thanks!


Posted by Russell Hauf on February 15, 2002 9:36 AM

In the workbook that is not working, go to the VBA editor, then select Tools-References. Make sure that "Visual Basic for Applications" is checked. If it's not, find it and check the box (the list is in alphabetical order).

Hope this helps,

Russell