cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 184
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.
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.