I'm relatively new here, but i think this would be more qualified for
the Programming forum.
but the answer is either
Sheet1.Select
or
Sheets("SheetNameHere").Select

The first example goes by the unchangeable excel-given name of the
sheet, the second by the name that you give it.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=275115