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