lcSheetName = "Whatever"
oExcel.Sheets(lcSheetName).Activate()
* or
lnSheetNumber = 2
oExcel.Sheets(lnSheetNumber).Activate()

>I haven't done much with "automation" by am a somewhat familar with the basics but I can't seem to figure this out.
>
>How do you change the "activesheet?" For example, if I add three worksheets how to I switch back and forth between the thee worksheets, thus making #1 the activesheet and then #2 the activesheet and then #3 the activesheet, etc.
>
>Robert Wright