Application screenupdating true catherine reitman dating
And then put a debug.print before/after each line (including before after the select line). and then put a debug print after the called sub ends and the code returns to the original sub. Well that narrows it down to the selecting I guess, and I guess further that it's specifically the selection of a sheet that wasn't the active sheet when you launched the macro.
And then put a debug.print before/after each line (including before after the select line).
As you can read: starting in cell A1 a value of "99" will be entered in the selected cell then the cursor will move one cell down to enter "99", repeat the process until the row number of the selected cell is 3000 and come back to cell A1.
Column Set rng = Range("A1") 'effort to stop screen flicker Debug. Adding these two lines on the outskirts of you code cause no screen flashing, and the application seems to freeze while the program is running. I'm starting to worry about the transe-like state I go into every time I run it...... Screen Updating = True Is there an equivalent in CATIA? Enable Events = True End Sub Sub DP_disbursement() Application. Still, any ideas why the Screen Updating = False doesn't work when I select a different sheet? Is it because the selection was performed in a different sub?