Results 1 to 5 of 5

Excel 2007 : Creat worksheets and name them from a range of cells

Threaded View

  1. 07-07-2009, 04:04 AM #1
    furiousfox
    furiousfox is offline
    Registered User
    Join Date
    08-08-2008
    Location
    Johannesburg
    MS-Off Ver
    2007
    Posts
    55

    Creat worksheets and name them from a range of cells

    Hi All
    I have a range cells (A1:A20) each have a word inside.

    How can I create a macro to generate/populate 20 worksheets that the names taken from the cells?

    Thanks in advance for your help

    Amit

    P.S
    This one doesn't help http://www.excelforum.com/excel-work...heet-name.html
    Last edited by furiousfox; 07-09-2009 at 01:27 PM. Reason: Update
    Using Excel 2007.
    Amit Cohen
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1