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:

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


    try:
    ActiveSheet.Name = Range("A1")


    Regards
    Claus B.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Nov 26, 2013
    #2
    1. Advertisements

  3. Garry

    Garry Guest

    On Tuesday, 26 November 2013 17:41:42 UTC, Claus Busch wrote:
    > Hi,
    >
    >
    >
    > Am Tue, 26 Nov 2013 09:30:11 -0800 (PST) schrieb Garry:
    >
    >
    >
    > > 1) Is it possible via a macro To take the value of say Cell (A1) and rename the current sheet you have focus on.

    >
    >
    >
    > try:
    >
    > ActiveSheet.Name = Range("A1")
    >
    >
    >
    >
    >
    > Regards
    >
    > Claus B.
    >
    > --
    >
    > Win XP PRof SP2 / Vista Ultimate SP2
    >
    > Office 2003 SP2 /2007 Ultimate SP2


    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:

    > Im sorry, Could you please tell me where this goes in the sheet.

    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.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Nov 26, 2013
    #4
    1. Advertisements

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.
Similar Threads
  1. Sylvia
    Replies:
    2
    Views:
    176
  2. Don Guillett
    Replies:
    2
    Views:
    147
    Don Guillett
    Jun 3, 2004
  3. Margie
    Replies:
    1
    Views:
    184
    Charlie
    Jul 2, 2004
  4. jonwyn

    how do I rename a sheet

    jonwyn, Mar 1, 2005, in forum: Excel Beginners
    Replies:
    2
    Views:
    84
    Trevor Shuttleworth
    Mar 1, 2005
  5. macgilgamesh

    Cell Total shown Sheet to Sheet

    macgilgamesh, Oct 7, 2005, in forum: Excel Beginners
    Replies:
    3
    Views:
    99
    macgilgamesh
    Oct 8, 2005
  6. Samad
    Replies:
    2
    Views:
    80
  7. Zane

    how can you rename a workgroup from a cell

    Zane, Oct 11, 2006, in forum: Excel Beginners
    Replies:
    1
    Views:
    101
  8. John G.

    Rename tab on cell event

    John G., May 7, 2008, in forum: Excel Beginners
    Replies:
    13
    Views:
    134
    Gord Dibben
    Jul 9, 2008
Loading...