Worksheetchange question

[Mr930]

I have some VBA code where I do some calculations and inside a loop, I write several numbers back to my spreadsheet. My questions is, if I check for a Worksheet change event, is the WorksheetChange() function called for each number I write in the VBA code (every iteration of the loop), or is it called only after the whole loop is executed?

I have my calculations (VBA) start when certain cells are changed, but my code writes back to the spreadsheet and I don't need the change event called for each one of those, but only after I have done all the writes.

thanks
Fred Emmerich

 

[VoG]

It is triggered for every change. You can suppress that like this

Application.EnableEvents = False
'
'code to write
'
Application.EnableEvents = True
'code to write last value

 

[Mr930]

Perfect, thanks!