VBA: Select a Worksheet by Tab Name

August 14th, 2004 | Categories: Worksheets | Tags: , ,
-->

If you need the flexibility to access a worksheet from VBA by Tab Name instead of sheet number, here’s how.

Sheets("TabNameGoesHere").Select
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. Sergio
    May 27th, 2010 at 23:18
    Reply | Quote | #1

    ActiveSheet.Name = SheetName

  2. kashif
    July 8th, 2011 at 06:10
    Reply | Quote | #2

    Thanx… It is helpful :)