use of function <target>

[R.VENKATARAMAN]

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

 

[Bob Phillips]

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]

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

 

[Bob Phillips]

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)