thanks . I shall try to assimilate this


JE McGimpsey wrote in message
...
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




In article ,
"R.VENKATARAMAN" &&& wrote:

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