<div>
Thanks. I didn't know I can use an Array of shape names. It made it a lot simpler!!!!!
</div>


Thanks. I didn't know I can use an Array of shape names. It made it a lot simpler!!!!!

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
My problem is this. For example, I know the syntax looks like<br />
Sheet1.Shapes.Range(Array(<wbr />&quot;Rectangle<wbr /> 1&quot;, &quot;Rectangle 2&quot;, &quot;Rectangle 3&quot;)).Select<br />
<br />
I need to be able to construct a string &quot;Rectangle 1&quot;, &quot;Rectangle 2&quot;, &quot;Rectangle 3&quot; programmatically, right? But when I do I get an extra set of &quot;&nbsp;that I cannot get rid of, and I get an error saying &quot;selected item not found&quot;.<br />
(I should clarify, the shapes will have different names. ie. not always the same. Hence programmatically)<br />
<br />
So, how can I select multiple shapes please?<br />
Thanks
</div>
</div>


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?
Thanks

Excel 2013 VBA - select multiple shapes

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.