use of function <target
 

I find I am able to use <target only in event modules of sheet or this
workbook but not in standarad module nor as worksheet funciton.. I would
like to have some more ideas of useof <target. I find I can use
<activecell instead of <target in standard module.
thanks regards

use of function <target
 

Target is just the name of an argument. In a worksheet event code procedure
such as Change, VBA passes the target cell(s) to the event procedure.

Target is just a convenient name, you could use anything you want, and as
long as you stay consistent, it will work (try it!).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R.VENKATARAMAN" &&& wrote in message
...
I find I am able to use <target only in event modules of sheet or this
workbook but not in standarad module nor as worksheet funciton.. I would
like to have some more ideas of useof <target. I find I can use
<activecell instead of <target in standard module.
thanks regards

use of function <target
 

thank you for that clarification. i experimented. I used in worksheet_change
event instead of <target the argument <cell. it works.

Bob Phillips wrote in message
...
Target is just the name of an argument. In a worksheet event code
procedure
such as Change, VBA passes the target cell(s) to the event procedure.

Target is just a convenient name, you could use anything you want, and as
long as you stay consistent, it will work (try it!).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R.VENKATARAMAN" &&& wrote in message
...
I find I am able to use <target only in event modules of sheet or this
workbook but not in standarad module nor as worksheet funciton.. I
would
like to have some more ideas of useof <target. I find I can use
<activecell instead of <target in standard module.
thanks regards

use of function <target
 

The reason we all use target is partly because it is a meaningful name, but
more relevant is the fact that when you use the dropdowns in the worksheet
code module then it creates an outline procedure with Target already defined
as its range argument name.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R.VENKATARAMAN" &&& wrote in message
...
thank you for that clarification. i experimented. I used in
worksheet_change
event instead of <target the argument <cell. it works.

Bob Phillips wrote in message
...
Target is just the name of an argument. In a worksheet event code
procedure
such as Change, VBA passes the target cell(s) to the event procedure.

Target is just a convenient name, you could use anything you want, and
as
long as you stay consistent, it will work (try it!).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R.VENKATARAMAN" &&& wrote in message
...
I find I am able to use <target only in event modules of sheet or
this
workbook but not in standarad module nor as worksheet funciton.. I
would
like to have some more ideas of useof <target. I find I can use
<activecell instead of <target in standard module.
thanks regards