Error | Copying Worksheet from Closed WB to Active WB.

[TryingBest]

Hi,

This code gives me an error. Unable to get why .. as where I see the same code for copying a sheet from closed workbook to active (This) workbook.
Please help!

Sub copyFirstWS()
    Dim wb As Workbook

    Set wb = Workbooks.Open("C:\Users\-")

    With ThisWorkbook
        wb.Worksheets(1).Copy Before:=.Worksheets(.Worksheets.Count)
    End With

   wb.Close savechanges:=False


End Sub

 

[Anthony47]

Thank you for the feedback