Sub Worksheet_Change

[vhanacek]

Hi everybody
Does any SUB exist like "Sub Worksheet_Change" , but the sub should be called only if cells in some range of the sheet are changed?....to save the time
I use there a function which put some values into some cells, what means that the worksheet is changed again and the SUB is called again and again.
Thanks

 

[acw]

Hi

Within the worksheet change event sub, turn off the events

application.enableevents = false

Then do you processing.

Remember to change it back again at the end of the sub

application.enableevents = true

It is often worthwhile to put in an error trap to make sure the events are turned on again just in case.

HTH

Tony