Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy from 1 sheet to another
I have some data on my main sheet and I want some of it to be automatically
copied onto another sheet. I have got it to work, using a macro, but my screen flickers when it jumps to sheet 2 and back again. Is there a way of not having the 'flicker'? |
#2
|
|||
|
|||
Have a look at ScreenUpdating Property in help.
-- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "SDeVuyst" wrote in message ... I have some data on my main sheet and I want some of it to be automatically copied onto another sheet. I have got it to work, using a macro, but my screen flickers when it jumps to sheet 2 and back again. Is there a way of not having the 'flicker'? |
#3
|
|||
|
|||
Hi SDeVuyst,
Try: Application.ScreenUpdating = False 'Your code Application.ScreenUpdating = True Or, better still, rewrite you code to avoid making selections or switching sheets. --- Regards, Norman "SDeVuyst" wrote in message ... I have some data on my main sheet and I want some of it to be automatically copied onto another sheet. I have got it to work, using a macro, but my screen flickers when it jumps to sheet 2 and back again. Is there a way of not having the 'flicker'? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data in other sheet | Excel Worksheet Functions | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
How Can I copy a sheet that has hidden rows without copying the h. | Excel Worksheet Functions |