Apparently, if I copy data from a location on the worksheet, and then paste this data into "Target", the worksheet_change event get triggered. However, if I try to write to Target.value, or even another cell, an error is generated.

I copied your code and pasted it in Sheet1 module.

I see no errors when I change the value in a1. I do not see any values
being copied.