I have wrote the following that will copy the first worksheet entirely to a new one, at the end of the current workbook.
Sub Copy() Dim test As Worksheet Sheets(1).Copy After:=Sheets(Sheets.Count) Set test = ActiveSheet test.Name = "copied sheet!" End Sub
However, I figured that I really just need to copy the data in columns A to I only, I don’t care of the rest of the columns.
How can I do this please? Any help