View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Change event on single cell fires many times

Hi XP,


But my code does not differ: I copied it from my module...
I'm curious, why do you say you think it differs?


(1) Your code had the appearance of pseudo code

(2) I would not expect changes in formula dependent values to
fire the Worksheet_Change event

However, I am pleased that the conventional methodology of
deactivating and subsequently reactivating events has resolved
your problem.


---
Regards,
Norman