Microsoft Office Forums - View Single Post - [Solved] Use function to select another worksheet

Logit · 04-26-2017, 07:28 PM

VBA Copy Worksheet: To Specific Workbook

Either macro needs to be pasted into a Routine Module in the workbook you are copying FROM.

Please find the below example, It will show you how to Copy the Worksheet named ‘Sheet1’ to Specific workbook before ‘Sheet3’.

Code:

Sub CopySheet_SpecificWorkbook ()
Sheets("Sheet1").Copy Before:=Workbooks("YourWorkbookName.xls").Sheets(“Sheet3”)
End Sub

Please find the below example, It will Copy the active worksheet to Specific workbook after ‘Sheet3’.

Code:

Sub CopySheet_SpecificWorkbook ()
ActiveSheet.Copy After:=Workbooks("YourWorkbookName.xls"). Sheets(“Sheet3”)
End Sub

Resource :

https://analysistabs.com/vba/copy-worksheet/