JMB Wrote:
You're probably already aware of it, but for the OP's benefit - in this
case
Application.Trim uses the Excel workbook version of the function
instead of
the VBA version of the function. In this example, Application is not
optional - you have to know which Trim function you want to use as
they
return different results.

Application.Trim is the same as using
Application.WorksheetFunction.Trim

When in doubt, check VBA help - it usually indicates if something is
optional.


"AA2e72E" wrote:

It is somewhat confusing since the prefix Application sometimes
returns a
different result. For example:

?Trim(" This is an example ")
This is an example
?Application.Trim(" This is an example ")
This is an example

I tend to use the Application prefix all the time, even though it is
optional in may contexts.Hi, JMB, AA2e72E, Harald,

Thank you all for your input. I will hash over this info.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=552874