worksheet.copy - without before or after

[lezawang]

Hi
If I run the code below, it will create a file with the copied sheet. What is the interpretation of that? why excel doing that if a user did not specify after or before? Thank you very much.

Sub copysheet()
    'to copy a sheet
    Dim x As Integer
    x = InputBox("enter sheet#")
    Workbooks(1).Worksheets(x).Copy
End Sub

 

[DanteAmor]

Remarks
If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the copied Worksheet object.

Check the following link

https://docs.microsoft.com/en-us/office/vba/api/excel.worksheet.copy

 

[lezawang]

Thank you so much.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.