View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default worksheet_change event when multiple cells changed (pasted)

Hi
normally the chnage event should be triggered in this
case. you may loop through the range 'target' in this case.

could you post your existing code?


-----Original Message-----
I have a working worksheet_change procedure, but I want

it to work also
when multiple cells are changed simultaneously (pasted).

Unfortunately
there is no worksheet_paste event, although it does count

as a change
if only pasting one cell.

Is there a way I can easily trigger a "worksheet_change"

event to
multiple cells or even a whole column?


---
Message posted from http://www.ExcelForum.com/

.