Just for fun, run Rob Bovey's code cleaner on the file and see if it clears
up.

http://www.appspro.com

--
Regards,
Tom Ogilvy

John Wilson wrote in message
...
Dennis,

I have run into that very problem myself
Was wondering if I was the only one that experienced this problem.

The most rational explanation advanced was that Excel may be
trying to extract the Left( )
and similar functions that may be contained in one of the other object
libraries listed under Tools-References, which is why writing
VBA.Left( )
gets
you to the proper one.
That does make sense.

changing Left( ) to VBA.Left( ),
and similarly with Chr( ), Mid( ), Right( ), Date, Space( ), etc.
Did that already on all my workbooks.

Still at a loss as to why it suddenly became a requirement???
Obviously, something that I (and yourself) did, but what??
I have no clue.

Thanks for the explanation,
John

"DennisE" wrote in message
...
John,

I have run into that very problem myself
from time to time as I installed Excel software with extensive VBA
macros
on various computers. Tools-References
never showed any references as missing,
and code checking for a broken link
never revealed one either (see page 512
of Excel 2002 VBA by Bullen et al for the
technique). What invariable fixed the problem was doing a reinstall of
Office
and if that didn't work of both Office and
the Windows operating system. (This did not win me friends, however,
because of
the down-time required to effect this.)

When I read your message to the forum, I did a search of the MS
Knowledge
Base
and found nothing on the topic there. But when I did a search on Google
with
keyword VBA.Left found several articles
on the subject. The most rational explanation advanced was that Excel
may
be
trying to extract the Left( )
and similar functions that may be contained in one of the other object
libraries listed under Tools-References, which is why writing
VBA.Left( )
gets
you to the proper one. Now that i know this, I will do a search and
replace of
all built-in functions in my Excel programs, changing Left( ) to
VBA.Left( ),
and similarly with Chr( ), Mid( ), Right( ), Date, Space( ), etc.

-- Dennis Eisen