"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