Worksheet change endless iterations

[insomniac53]

I am having trouble understanding the correct used of Worksheet_Change.
When used to target a specific cell, if that cell is altered, then the change is called again... and again and again.
I've simplified the code below to show what I mean.

Please Login or Register  to view this content.

What is the best way of tackling this problem, avoiding an endless cycle of calling?

[AlphaFrog]

Please Login or Register  to view this content.

[insomniac53]

That's the one! I should have researched it first as it's been asked before, but never mind, thank you so much.

[AlphaFrog]

You're welcome.

If you have a complex procedure that might error, use an error handler to always re-enable your events.

This is a simple error handler.

Please Login or Register  to view this content.