Using "Application.Screenupdating = False " will disable the Screen flickering. you can enable after the loop. Also, I using ActiveCell for time consuming tasks. there are alternatives like With Selection etc.. if you could post more details or the code snippet, we can suggest more.
On Thu, Sep 11, 2008 at 8:15 PM, Lawrence <[EMAIL PROTECTED]> wrote: > > Hi > > At the moment I am using Activate to switch between sheets and use > ActiveCell and Offset to move between cells, however I also have many > loops...so using this method takes upwards of 10 seconds to execute > and also the screen flickers lots! Is there any more efficient ways of > navigating between cells? > > Thanks > > Lawrence > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
