+ Reply to Thread
Results 1 to 3 of 3

List Values Of Multiple Sheets

Hybrid View

wegkruip List Values Of Multiple Sheets 09-29-2009, 06:55 AM
rwgrietveld Re: List Values Of Multiple... 09-29-2009, 07:15 AM
wegkruip Re: List Values Of Multiple... 09-29-2009, 09:41 AM
  1. #1
    Registered User
    Join Date
    02-25-2009
    Location
    bfn,rsa
    MS-Off Ver
    Excel 2003
    Posts
    17

    List Values Of Multiple Sheets

    Hi sir/madam

    I’ve got this workbook.
    Is there a way to make the macro only list the selected cell values of Sheet6 and higher (not list the selected cell values of sheets 1, 2, 3, 4, 5)

    Any help would be appreciated
    Thank you
    Attached Files Attached Files
    Last edited by wegkruip; 09-29-2009 at 09:40 AM.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: List Values Of Multiple Sheets

    Change this line

    If Sh.Name <> Newsh.Name And Sh.Visible And Sh.Index >= 6 Then
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Registered User
    Join Date
    02-25-2009
    Location
    bfn,rsa
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: List Values Of Multiple Sheets

    Thanks allot!
    And thanks for the quick reply

+ 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