definition of target

[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

 

[JE McGimpsey]

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

 

[R.VENKATARAMAN]

thanks . I shall try to assimilate this

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