>I can't seem to figure out how to set the Activesheet in excel if I don't know the name of the sheet that I want to switch to. Isn't there a mechanism to select the 1st sheet in the workbook and then the 2nd sheet, and so forth, cycling through all of the worksheets in the workbook in other words? Thanks in advance. -Rick
For Each ws in oApp.Worksheets
ws.Activate()
EndFor
Or simply oApp.Worksheets(1).Activate()