Thread: worksheet_change event when multiple cells changed (pasted)
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Dianne Butterworth[_2_] Dianne Butterworth[_2_] is offline
external usenet poster
  
Posts: 19
Default worksheet_change event when multiple cells changed (pasted)
In your code, you have the following:

If Target.Cells.Count 1 Then
Exit Sub
End If

which means that if you have more than one cell changing, the rest of your
code does not execute.

--
HTH,
Dianne Butterworth

I did he http://pwei.org/dn/vba.txt


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


Reply With QuoteReply With Quote