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.
Bookmarks