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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
