Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
"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
| Check out our Excel VBA Resources
|
 |
 |
 |
 |
 |
Re: "Left" "Trim" function errors in VBA
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"
Dave
OzGrid Business Applications
Thanks for the Help Dave
Posted by Paul E. on April 02, 2001 6:45 AM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.