| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop the "flashing" when I execute an Excel macro?
When I run an Excel macro containing a lot of Copy and Paste functions, the
worksheets it is copying and pasting from flash on the screen. Is there a way I can stop this from occurring? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop the "flashing" when I execute an Excel macro?
Application.ScreenUpdating = False
'your code Application.ScreenUpdating = True If this post helps click Yes --------------- Jacob Skaria "Corinne" wrote: When I run an Excel macro containing a lot of Copy and Paste functions, the worksheets it is copying and pasting from flash on the screen. Is there a way I can stop this from occurring? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop the "flashing" when I execute an Excel macro?
application.screenupdating = false
'your code application.screenupdating = true -- HTH... Jim Thomlinson "Corinne" wrote: When I run an Excel macro containing a lot of Copy and Paste functions, the worksheets it is copying and pasting from flash on the screen. Is there a way I can stop this from occurring? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop the "flashing" when I execute an Excel macro?
Add these lines to you code:
Sub Foo() Application.ScreenUpdating = False your code here Application.ScreenUpdating = True End Sub -- Biff Microsoft Excel MVP "Corinne" wrote in message ... When I run an Excel macro containing a lot of Copy and Paste functions, the worksheets it is copying and pasting from flash on the screen. Is there a way I can stop this from occurring? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stop the "flashing" when I execute an Excel macro?
The "flashing" usually comes from "selecting" things.
Your code can usually be edited to remove all those "selects" to stop the jumping around and make your code run faster. Post your code or go with the screenupdating method others posted. Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 10:37:02 -0700, Corinne wrote: When I run an Excel macro containing a lot of Copy and Paste functions, the worksheets it is copying and pasting from flash on the screen. Is there a way I can stop this from occurring? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| What does this mean? "Can't execute code in design mode" | Excel Discussion (Misc queries) | |||
| "method 'execute' of object 'find' failed" | Excel Discussion (Misc queries) | |||
| Screen "Flashing" on Window change | Excel Discussion (Misc queries) | |||
Linear Mode
