+ Reply to Thread
Results 1 to 2 of 2

How to avoid sheets select.

  1. #1
    Registered User
    Join Date
    02-22-2017
    Location
    Haarlem
    MS-Off Ver
    Excel 2010/2013
    Posts
    49

    How to avoid sheets select.

    I have a code that picks data from a outlook outlook into excel. I use sheets select in this but with refreshing it getting slow. So I want to avoid sheets select. But I don't how to do this with this code.

    See code below
    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 04-17-2020 at 10:45 AM. Reason: Moved to Outlook section

  2. #2
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: How to avoid sheets select.

    First of all, I'd switch off Application.ScreenUpdating at the beginning - don't forget to switch back on again afterwards, then see below...
    Please Login or Register  to view this content.
    Additionally, it's generally not a good idea to use whole columns or rows, as with certain formulae it can really have a speed and resources impact. Try to limit the range that needs processing instead.

    Tim
    Never stop learning!
    <--- please consider *-ing !

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How Can I Avoid Using .Select in VBA?
    By jdcortez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-04-2019, 11:28 PM
  2. How do avoid Select when coding TextBoxes
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2018, 10:53 AM
  3. [SOLVED] How to avoid having to select same range twice?
    By Vonvorx in forum Excel General
    Replies: 4
    Last Post: 04-30-2016, 07:50 AM
  4. Avoid view jumping around with select and sort from macro
    By lemonstar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2012, 07:34 PM
  5. Can arrays be identified by i = X TO Y statements? (Avoid select Case)
    By macyarab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2009, 08:21 AM
  6. [SOLVED] How to avoid name conflicts while copying sheets
    By jaffar in forum Excel General
    Replies: 1
    Last Post: 05-30-2006, 12:20 PM
  7. Trying to Avoid Selecting Sheets
    By Kevin O'Neill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2005, 05:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1