Results 1 to 5 of 5

List of Tab names + 3 specific cell from each sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-04-2013
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    130

    List of Tab names + 3 specific cell from each sheet

    Hi all,

    As usual had a reasonably thorough Google and cannot find an answer so I hope you don't mind me asking another question.

    I'm trying to make a list of all the tab names in a spreadsheet, that's easy enough, but I would also like to copy the data into the adjacent cells of 3 specific cells E2, E3 & S37 from each sheet.

    Below is the macro I currently use to list the sheet names.

    Sub ListSheetNames()
        Dim R As Range
        Dim WS As Worksheet
        Set R = ActiveCell
        For Each WS In ThisWorkbook.Worksheets
            R.Value = WS.Name
            Set R = R(2, 1)
        Next WS
    End Sub
    As always any advise greatly appreciated and thanks for looking.
    Last edited by JohnDoh; 03-18-2016 at 06:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-07-2015, 07:15 PM
  2. [SOLVED] Finding a specific list of names inside larger list
    By Boxed in forum Excel General
    Replies: 7
    Last Post: 09-13-2013, 06:46 PM
  3. [SOLVED] Saving cell contents to specific cell in another sheet based on value in list
    By lukestkd in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-24-2013, 02:51 PM
  4. Replies: 8
    Last Post: 07-05-2012, 09:51 AM
  5. Getting a list of Sheet Names by excluding certain Sheet Names instantenously..
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-09-2012, 12:16 PM
  6. Replies: 11
    Last Post: 10-06-2011, 02:26 PM
  7. Replies: 1
    Last Post: 10-05-2011, 04:57 PM

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