Hi all,

What significance does the word "application" have in the second line
of first code.



Code:
--------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1")) Is Nothing Then
Select Case Target
--------------------


Code:
--------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
Select Case Range("A1").Value
--------------------


--
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

Refers to the application object, but it is optional for the Intersect method
so both of your subroutines should function the same.

"Desert Piranha" wrote:


Hi all,

What significance does the word "application" have in the second line
of first code.



Code:
--------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1")) Is Nothing Then
Select Case Target
--------------------


Code:
--------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
Select Case Range("A1").Value
--------------------


--
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

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.

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.

That happens when you call functions that are known worksheetfunctions
Application.Trim
equals
Application.worksheetfunction.Trim
so the difference is VB's Trim vs Excel's Trim.

This has to do with backwards compatibility I think. In my second youth, aka
Excel 5, we wrote things like
Application.Sum(5,6,7)

HTH. Best wishes Harald

"AA2e72E" skrev i melding
...
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.

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