stopping change in cell from refiring worksheet change

[cogswel__cogs]

Hi
I have worksheet change code that make adjustments based on certain cell changing.

After one particular cell change I catch the target value and put it into data area,
Afterward I want to replace the target cell with a formula. But when I paste in the formula it refires the workcheet change code again.
Is there a way to shut off the workheet change macro while the code is running?

All help is greatly appreciated.

 

[HighAndWilder]

Hi
I have worksheet change code that make adjustments based on certain cell changing.

After one particular cell change I catch the target value and put it into data area,
Afterward I want to replace the target cell with a formula. But when I paste in the formula it refires the workcheet change code again.
Is there a way to shut off the workheet change macro while the code is running?

All help is greatly appreciated.

EnableEvents will enable you to control the firing of the worksheet change event procedure.

Application.EnableEvents = False
' Code to run here.
Application.EnableEvents = True