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.
I appreciate any help.
Please Login or Register to view this content.
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
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
Without a sample??
Something like that maybe? This is a wild guess.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks