Rename Sheet from a cell value

Discussion in 'Excel Beginners' started by Garry, Nov 26, 2013.

  1. Garry

    Garry Guest

    1) Is it possible via a macro To take the value of say Cell (A1) and rename the current sheet you have focus on.


    Thanks

    garry
     
    Garry, Nov 26, 2013
    #1
    1. Advertisements

  2. Garry

    Claus Busch Guest

    Hi,

    Am Tue, 26 Nov 2013 09:30:11 -0800 (PST) schrieb Garry:
    try:
    ActiveSheet.Name = Range("A1")


    Regards
    Claus B.
     
    Claus Busch, Nov 26, 2013
    #2
    1. Advertisements

  3. Garry

    Garry Guest

    Im sorry, Could you please tell me where this goes in the sheet. Sorry Im a bit thick.
    Garry
     
    Garry, Nov 26, 2013
    #3
  4. Garry

    Claus Busch Guest

    Hi,

    Am Tue, 26 Nov 2013 10:51:12 -0800 (PST) schrieb Garry:
    Press Alt+F11, insert a standard module and paste the code into the code
    window:

    Sub Test()
    ActiveSheet.Name = Range("A1")
    End Sub

    Back on your sheet you can run the nacro "Test" to name the sheet.


    Regards
    Claus B.
     
    Claus Busch, Nov 26, 2013
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.