Nevermind, I found the solution.

I have some data that will be pasted into a worksheet. When it's pasted, I'm using the Worksheet_Change event to sort the data and then change a few values. The problem is that when I go to change values, it will call the Worksheet_Change event again, so my code becomes stuck in a loop.

Is there a way to temporarily turn-off this event until my code is done running?

SOLUTION:
Please Login or Register  to view this content.