+ Reply to Thread
Results 1 to 2 of 2

Rename sheet by refer to a cell

Hybrid View

  1. #1
    Registered User
    Join Date
    01-13-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    76

    Rename sheet by refer to a cell

    Is there a way to rename the sheet with by refer to a cell at certain worksheet?
    For example, I want my new sheet's name is "6 graph 10cm" , so how should i modify the code below?
    I wrote 6graph in the syntax and the 10cm is located at Sheet2!D10. How could I combine both of the text so I will get a new sheet with the name "6 graph 10cm"

    Sheets.Add(After:=Sheets(Sheets.Count)).Name = "6 graph" & Sheets("2").D10

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Rename sheet by refer to a cell

    Hi..
    Try this:

    Sheets.Add(After:=Sheets(Sheets.Count)).Name = "6 graph" & Sheets("Sheet2").Range("D10")

    Regards...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1