+ Reply to Thread
Results 1 to 7 of 7

Macro to build a new sheet

  1. #1
    Registered User
    Join Date
    03-01-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    58

    Macro to build a new sheet

    Hi,

    Does anyone know how to create a macro that create a new sheet?

    regards
    Last edited by Adam Brave; 03-02-2012 at 11:29 AM.

  2. #2
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,837

    Re: Macro para criar uma nova sheet

    Exemple:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-01-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Macro to build a new sheet

    It doesn't work. If I want that the new sheet get the name "football" how do I change your code?

  4. #4
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: Macro to build a new sheet

    To add a new sheet at the end of the sheets list and input the name you want it to have:

    Please Login or Register  to view this content.
    I hope that helps.

  5. #5
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,837

    Re: Macro to build a new sheet

    Put the name you want in A1

  6. #6
    Registered User
    Join Date
    03-01-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Macro to build a new sheet

    It works perfect

    Tkz!!

  7. #7
    Forum Contributor
    Join Date
    02-07-2012
    Location
    MIA
    MS-Off Ver
    Excel 2007, 2010
    Posts
    429

    Re: Macro to build a new sheet

    Mark as solved

+ 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