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