Select all shapes with similar names: Runtime error 1004
I am having trouble selecting only the shapes that contain a specific string within the name. The red line in the code is my problem.
I am searching for all the shapes within the sheet, storing the names of the shapes I wan't in an array and placing the join output of the array into a string. I can't get past this point.
Please Login or Register to view this content.
the following article may help you out
https://stackoverflow.com/questions/...l-visual-basic
also you don't need the chr(34) to select the shape
and you are making 1 long string which you use to select a shape and that shape doesn't exist
Last edited by Joske920; 11-07-2020 at 09:31 PM.
Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
If you have been helped, maybe you could click the *
Please Login or Register to view this content.
Last edited by AlphaFrog; 11-07-2020 at 09:33 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
@AlphaFrog
does that not only go select all shapes 1 by 1 and not a group?
The Replace:=False argument selects the group.
Thank you. This worked.Originally Posted by Joske920
Wow. This was super straight forward. Thanks, I learned something today!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