LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default flashing screen driving me bonkers!

Good morning all! (evening or night as the case may be)
I am new to VBA coding so pardon my ignorance please, but I could
really use some help.

I have created a loop that cycles through over 5000 rows of
information from one workbook, seeks out and sums amounts that meet
multiple criteria and places those sums into a new workbook. As my
code runs my screen flashes between the two workbooks and is very
annoying!

My question is... is there a way to have these calculations running in
the background? Setting visible properties? Any suggestions would be
greatly appreciated!!!

Thanks for your time,
Deb
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Screen flashing teepee[_3_] Excel Discussion (Misc queries) 0 November 26th 08 12:20 AM
How to stop the screen from 'flashing' when copying and pasting BaggieDan Excel Discussion (Misc queries) 4 October 9th 08 10:31 PM
Screen "Flashing" on Window change Neal Zimm Excel Discussion (Misc queries) 0 September 28th 06 01:35 PM
Screen flashing why? Chet Excel Discussion (Misc queries) 1 May 16th 06 08:25 PM
Screen is flashing when VBA adding objects into Excel sheet? Don Guillett[_4_] Excel Programming 0 July 8th 03 03:01 PM


All times are GMT +1. The time now is 09:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"