Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't I use SUM when pasting HTML code into new sheet. | Excel Worksheet Functions | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Check cell for data before running code | Excel Programming | |||
Over-Eager code is pasting 3 times | Excel Programming |