rename sheets 1 thru 25 to a new name from a table RRS feed

  • Question

  • I need to rename sheets 1 thru 25.  MY HANGUP IS RETRIEVING THE SHeet using the following; can anyone help?

      Sheets("ConfTeam & PostCnt").Select   ' this statement is not correct even though it will compile
           ActiveSheet.Name = TeamName

    Friday, September 30, 2011 6:50 PM