Thanks for that I have modified all my code and it runs in under 1
second now with no epileptic fits!
On Sep 11, 10:00 pm, jamesdavey <[EMAIL PROTECTED]> wrote:
> For a start, you don't need to activate the sheet to do things to it.
>
> You can write for example:
>
> Sheet1.range("a1").offset.... etc
>
> As for the activecell and offsetting there are better ways but depends
> on how your workbook is set up (named ranges are useful here)
>
> If you post your actual code I can suggest some changes to speed it
> up
>
> On Sep 11, 3: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- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
