MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"Left" "Trim" function errors in VBA

Posted by Paul E. on March 30, 2001 10:04 AM

I am able to assign a variable in VBA using the TRIM or Left function in reference to a cell in Excel (i.e. myvariable = Trim(Range("A1") ) But when I try to execute this code on another PC I get the "Project or Library not found" error.

This is not the case for any other function I have invoked thus far. Does anyone have any idea as to how I might prevent this error from occurring, when this file is in use on another PC? Thanks

Posted by Dave Hawley on March 31, 2001 3:37 AM

Hi Paul

While in the VBE, go to Tools>References the missing file should be preceded with the word "Missing"

OzGrid Business Applications

Posted by Paul E. on April 02, 2001 6:45 AM

Thanks for the Help Dave