ouestque

<div>
Thank you Subodh. Will chartobjects.count always work? Is there a way to set the newly pasted object immediately to a variable instead?<br />
<br />
Example: (Doesn't work)<br />
Set ch2 = ws2.paste
</div>


<div>
Yes, it should work as it will always refer to the latest ChartObject copied to the Sheet2. Did it not work for you?
</div>


<div>
<div class="content wysiwyg-content">
What VBA would I need to copy a chart to another sheet in the same place but with a new name and half its normal size.<br />
<br />
In this case assume:<br />
*The chart is titled &quot;Chart1&quot; on &quot;Sheet1&quot; and it is going to be copied to &quot;Sheet2&quot; with the name &quot;New_Chart1&quot;<br />
*There are already various other random charts on Sheet1 and sheet2 with different names.
</div>
</div>


What VBA would I need to copy a chart to another sheet in the same place but with a new name and half its normal size.

In this case assume:
*The chart is titled "Chart1" on "Sheet1" and it is going to be copied to "Sheet2" with the name "New_Chart1"
*There are already various other random charts on Sheet1 and sheet2 with different names.

Excel VBA: Copy chart under different name

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.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.