At the start of the program use the following code ----- Application.screenupdating=false -----
before terminating the program, repeat the above code with 'true' on the right hand side. Akhilesh On Thu, Sep 11, 2008 at 11:45 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 > > > > -- Akhilesh Kumar Karna --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
