excel vba screen updating

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA screen updating

Excel VBA screen updating

resolvedResolved · Low Priority · Version 2003

Rahul has attended:
No courses

Excel VBA screen updating

Hi,

I am having some trouble with the screen update command. As recommended by the trainer, I used application.screenupdating = false at the beginning of my macro, but it still updates the spreadsheet and is really annoying for any end-user. I have lot of iterations happening within my macro. Any reason why this is happening? I don't select or activate within the macro, which means i don't use the clipboard. Not sure where the mistake is. Please do look into this. Thanks.

RE: Excel VBA screen updating

This is a duplicate post please see the other post for the solution.

Laura GB

Tue 27 Jan 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips


Server loaded in 0.07 secs.