<div>
Exactly what I suspected, but I needed some confirmation. Thank you!
</div>


Exactly what I suspected, but I needed some confirmation. Thank you!

<div>
<div class="content wysiwyg-content">
I have received a workbook to debug. &nbsp;Execution of the code stops on the following line with the error message it cannot be found.<br />
ActiveSheet.Shapes.Range(A<wbr />rray(&quot;Home<wbr />Lay&quot;)).Sel<wbr />ect<br />
<br />
Below is a list of all shapes on the active page.<br />
Shape Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Shape Type<br />
Group 125 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Group 125<br />
Group 126 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Group 126<br />
Group 127 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Group 127<br />
Group 128 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Group 128<br />
Picture 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Picture 1<br />
TextBox 102 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TextBox 102<br />
Picture 34 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Picture 34<br />
TextBox 33 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TextBox 33<br />
<br />
Any idea what is going on here?
</div>
</div>


I have received a workbook to debug.  Execution of the code stops on the following line with the error message it cannot be found.
ActiveSheet.Shapes.Range(Array("HomeLay")).Select

Below is a list of all shapes on the active page.
Shape Name	Shape Type
Group 125	Group 125
Group 126	Group 126
Group 127	Group 127
Group 128	Group 128
Picture 1	Picture 1
TextBox 102	TextBox 102
Picture 34	Picture 34
TextBox 33	TextBox 33

Any idea what is going on here?

Cannot find array

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

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