Can't switch between worksheets

[rnuage]

I'm trying to go back and forth between worksheets on a MAC (I normally work with a pc) and for some reason I can only switch once. The following code

Worksheets("Sheet2").Activate
Worksheets("Sheet1").Activate

works fine on the first statement and fails on the second with "Application or User defined Error."

I've tried using indexes instead of names, tried Sheets instead of Worksheets... I'm stuck. Any idea what this problem could be?

 

[TysonLPrice]

This is what I use without any problems. I'm a rookie at this stuff though:

Set xlWorksheet = Excel.Sheets(6) 'or whatever number
xlWorksheet.Activate