Is there equivalent vba code for Excel 2013?

[Lidsavr]

I just started running Excel 2013 and some of the vba code that I used for Excel 2010 isn't working. I get a "Subscript out of range" error when stepping through the code. The line reads:

Sheets(2).Select

Is there an Excel 2013 equivalent for this line of code (I don't want to use the sheet name)?

 

[Andrew Poulsom]

That code will work in Excel 2013 provided that there are at least 2 sheets in the ActiveWorkbook.

 

[Lidsavr]

Andrew,
Thank you for replying. There are two sheets in the workbook. The line prior is:

Sheets.Add After:=ActiveSheet

The workbook starts out with one sheet and the above code adds another. I then want to select the first sheet (left side of the workbook). Because the new sheet is active once it is added, I want to select the original sheet, which name is different depending on the month. Here is the code that I have up to the error (which is only in Excel 2013; it runs fine in Excel 2010):

Sheets.Add After:=ActiveSheet
Sheets(2).Select

Any idea what (if anything) I am doing wrong?

 

[Andrew Poulsom]

Wouldn't that be?

Sheets(1).Select

 

[snb_]

Avoid any 'select' or 'activate'
Use instead:

With Sheets.Add(, activesheet)
    .name="new sheet"
 '  your other code
end with