I have a worksheet into which I paste a block of data. After pasting, I run
some
VB code to do some editing, using the worksheet_change event. This
causes the code to run every time I make a change to the sheet, instead of
only when I do the paste.
I tried adding
If target.address = "$A$2" then
to the beginning of the procedure, but this causes the code to run only if I
paste a single value into cell A2, but not when I paste a block of data into
cells beginning with A2.
How can I make the code run only when I paste the block of data, and not on
every update to the worksheet?
Any suggestions would be greatly appreciated.