If you call it from a change event, you need to disable events before changing the worksheet, and re-enable events when you're done.