Yes, the line of code exists because there is no event which returns
just the cell(s) that were changed. Instead, Target returns the
*selected* cells when the change was made.

Thus Worksheet_Change can't tell whether you pasted into all of the
cells, or simply had a range selected and changed one cell.

To to that would require that you do something like saving the selected
range in a variable (or another range) when it was selected. Then when
the worksheet_change() fires, you could compare the new values to the
stored values, time-stamping each cell that changed. Note that since the
selection change occurs before the Worksheet_Change event, there's the
need to make that storage somewhat persistent.




In article ,
"Antonio Duarte" wrote:

So, is there any reason for the existence of this line of code?
Do you have any idea on what is happening?