Excel 2013 VBA - select multiple shapes
Posted on 2015-01-15
I have a number of small rectangles on a sheet. I can iterate through the shapes that are positioned within a selected cell range ok.
My problem is this. For example, I know the syntax looks like
Sheet1.Shapes.Range(Array("Rectangle 1", "Rectangle 2", "Rectangle 3")).Select
I need to be able to construct a string "Rectangle 1", "Rectangle 2", "Rectangle 3" programmatically, right? But when I do I get an extra set of " that I cannot get rid of, and I get an error saying "selected item not found".
(I should clarify, the shapes will have different names. ie. not always the same. Hence programmatically)
So, how can I select multiple shapes please?