<div>
on error resume next<br />
sheets(m14).copy<br />
on error goto 0
</div>


on error resume next
sheets(m14).copy
on error goto 0

<div>
<div class="content wysiwyg-content">
with VBA I want to copy a sheet where the name in cell M14 has the name of the sheet.<br />
<br />
i.e. if M14 = Option 3 copy the sheet name Option 3<br />
<br />
i.e. if M14 = Option 10 copy the sheet name Option 10<br />
<br />
Thanks in advance
</div>
</div>


with VBA I want to copy a sheet where the name in cell M14 has the name of the sheet.

i.e. if M14 = Option 3 copy the sheet name Option 3

i.e. if M14 = Option 10 copy the sheet name Option 10

Thanks in advance

Iif cell contains same name as any sheet in workbook copy sheet

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

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.