Screen Updating won't turn off

Hi,
I've been using this code for awhile and it hasn't been giving me any trouble until recently. Now the screen updating won't turn off like it did before. I've added other code to the workbook, but nothing I can think of that would interfere with the screen updating in this code. Does anyone see anything that could be the problem, or know what would interfere with the application.screenupdating=false?

Please Login or Register  to view this content.

Thanks.

Hello Jaron_t,

Try it like this;

Please Login or Register  to view this content.

Ok, got it. I discovered the problem was a change event. It basically said:

'detect if the active cell is in this range and
if so do this
if not don't do anything'

and in the 'if not' part I had a screenupdating=true, so when the macro went to select/copy/paste, it would trigger the change event, which would turn screen updating back on.

At least, that's what I think was going on...it's fixed anyway.

I read somewhere on google that screen updating defaults to true after a macro runs anyway, so I guess I didn't have to be turning it back on all the time.

If anyone else was trying to figure this out, thanks for your time.

Hello Jaron_t,

I have not seen your other Code, but if you have managed to solve the issue, good for you!

Please remember to mark your Thread as "Solved",