PDA

View Full Version : [SOLVED] About WorkSheet_Change Event VBA



rong3
10-01-2017, 07:31 PM
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
10-01-2017, 11:06 PM
Target is a range containing all changed cells, so you should use a for - each loop looping through the cells of Target.