Script crashes Excel

[dixib]

Hi,

I have created the below script.

Please Login or Register  to view this content.

Unfortunately it keeps crashing Excel. Is this because the for loop makes changes within the KeyCells range? I've tried making it write outside the range, and that seems to work just fine.
If I need the function to write within the KeyCells range, how do I do this without it crashing (triggering the scripts again, I guess)?

Thanks in advance.

[rorya]

Try this:

Please Login or Register  to view this content.

[bulina2k]

Hi dixib,

You could try disabling (Application. EnableEvents = False) and enabling it after:

Please Login or Register  to view this content.