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.
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.