About WorkSheet_Change Event VBA

[rong3]

Hi, I am working on a function that copy all value is pasted from Sheet A to Sheet B.
So i triggered by WorkSheet_Change Event when detecting value change from Sheet A then pass it to Sheet B but one by one.
What i ask for does the WorkSheet_Change Event work if i paste multi value and pass all of it to Sheet B.
I am really stuck on it, plz help me. Thanks in advance.

[Jan Karel Pieterse]

Target is a range containing all changed cells, so you should use a for - each loop looping through the cells of Target.