One way:

Sheets(1).Copy After:=ThisWorkbook.Sheets(1)

Note that the first line isn't required.


In article ,
CLR wrote:

Hi All........
I am opening a second Excel file and copying the only sheet therein back to
my original file. All code works fine, except that it requires me to
hardcode the SheetName of the second file. I would like to be able to
retrieve the sheet regardless of what it might be named.

Here's what I'm using now

Sheets("BUYER_CB").Select
Sheets("BUYER_CB").Copy After:=ThisWorkbook.Sheets(1)


TIA for any assistance
Vaya con Dios,
Chuck, CABGx3