Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Identify first worksheet in workbook (Excel 2003)

    I am trying to identify the first worksheet in a workbook via code. I then want to rename the worksheet and do other stuff with it. The other stuff is done and works. The rename is easy, but I need to go to the first sheet in a book.

    Thanks for any help

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Identify first worksheet in workbook (Excel 2003)

    Try:

    WorkSheets(1).Name = "My New Name"
    Legare Coleman

  3. #3
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Identify first worksheet in workbook (Excel 2003)

    Thank you, thank you!! Worked like a charm.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •