+ Reply to Thread
Results 1 to 4 of 4

Optimize Code by avoiding Select-Method

  1. #1
    Registered User
    Join Date
    08-21-2018
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    24

    Exclamation Optimize Code by avoiding Select-Method

    Hi guys,

    today i read an article about avoiding the select-method if you want to copy something from one sheet to another.
    My project copies shapes in a given range (dynRange) from an Excel-Sheet to a PowerPoint-Slide. How can i avoid the select method to optimize my code / to get a shorter runtime? I have like 1000 Shapes in different Ranges so it takes a long time to process.
    Please Login or Register  to view this content.
    I appreciate any help.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Optimize Code by avoiding Select-Method

    Without having a file to test on, instead of selecting you can try and get the name of the shape and past it to that region.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    08-21-2018
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    24

    Re: Optimize Code by avoiding Select-Method

    The file of mine is to complex to post it here. I am creating the +1000 shapes on the spot. So i dont have shape-names which i can use.
    Also i dont know how many shapes are on the sheet. it depends on the user input.
    Last edited by JonasBig2; 09-07-2018 at 09:55 AM. Reason: grammer

  4. #4
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Optimize Code by avoiding Select-Method

    Without a sample??
    Something like that maybe? This is a wild guess.
    Please Login or Register  to view this content.

+ 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. [SOLVED] PivotFields | Select Pivotitem avoiding false
    By ozstrik3r69 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2018, 10:00 AM
  2. Optimize macro by avoiding using for statements
    By alexholly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-16-2015, 01:07 AM
  3. Optimize a code
    By pezalmendra in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2015, 05:31 PM
  4. [SOLVED] How to optimize cost and material with formula, Solver or any method
    By jackson_hollon in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-29-2014, 12:58 PM
  5. Optimize code
    By miso.dca in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2011, 03:35 PM
  6. Optimize VBA code
    By doodlebug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2007, 07:53 AM
  7. [SOLVED] avoiding select
    By Ward Germonpré in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2005, 04:06 PM

Tags for this Thread

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