Judy Ward

Posts: n/a

What does ScreenUpdating = False do?

I have "borrowed" subroutines from this site (that work beautifully) that have:

ScreenUpdating = False
<code that changes the values of cells here
ScreenUpdating = True

I was wondering what setting the ScreenUpdating to false and back to true is
doing for me. I looked in Excel help (it was no help).

I would love a simple (I'm not an advanced user) explanation.
Thank you,
Judy

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Grouped Sheets and Formating	Pank Mehta	Excel Discussion (Misc queries)	3	March 24th 05 01:42 AM
link data to new workbook	WYN	Excel Discussion (Misc queries)	3	February 28th 05 06:19 AM
Grand Totals @ Same Place	Amber M	Excel Worksheet Functions	2	December 30th 04 07:13 PM

All times are GMT +1. The time now is 11:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us