View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lallen lallen is offline
external usenet poster
 
Posts: 17
Default running code after pasting data

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.