definition of target

  • Thread starter Thread starter R.VENKATARAMAN
  • Start date Start date
R

R.VENKATARAMAN

in some of the even programmes the term "target" is used. this term is
perhaps not avilable in modules.. "help" is not of much help on this term.
where can I get some information on this term. thanks
 
Target is just the default variable name assigned in some Event macros
(e.g., Worksheet_Change()) that contains a reference to the cell that
was changed.

You can change it if you want:

Private Sub Worksheet_SelectionChange(ByVal foo As Excel.Range)
MsgBox foo.Address
End Sub
 
thanks . I shall try to assimilate this


JE McGimpsey said:
Target is just the default variable name assigned in some Event macros
(e.g., Worksheet_Change()) that contains a reference to the cell that
was changed.

You can change it if you want:

Private Sub Worksheet_SelectionChange(ByVal foo As Excel.Range)
MsgBox foo.Address
End Sub
Click to expand...
 
Back
Top