Application.screenupdating = false (at the beggingin of your module) this will get rid of the flashing, as Excel is trying to update your GUI throughout the code. Try that first to see if there is noticable improvement in perfomance time...
As a rule i avoid activate and select in all my excel vba code, for performace reasons. The object exists, and can be manipulated, regardless of if you have it selected.... In your case, reference the cell rather than activating/selecting it. cells(x,y).value will let you assign or write a new value tril On Sep 11, 7:45 am, 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 -~----------~----~----~----~------~----~------~--~---
