+ Reply to Thread
Results 1 to 7 of 7

Help with a loop through all sheets

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007 - 2010
    Posts
    73

    Help with a loop through all sheets

    MorningReport.xls

    Hello guys,

    I have this macro, which I need to run in through all sheets but I haven't find the way. Could you help me? thanks!!


    Please Login or Register  to view this content.
    Last edited by jnh0; 08-13-2013 at 04:12 AM.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Help with a loop through all sheets

    attach please a sample file for testing
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    08-07-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007 - 2010
    Posts
    73

    Re: Help with a loop through all sheets

    Done you can find it at the top of my previous post! Thanks!!

  4. #4
    Registered User
    Join Date
    08-07-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007 - 2010
    Posts
    73

    Re: Help with a loop through all sheets

    Done guys, I found the way how to do it!

    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Help with a loop through all sheets

    This might need some tweaking (untested) but the concept should work:

    Please Login or Register  to view this content.
    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  6. #6
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Help with a loop through all sheets

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  7. #7
    Registered User
    Join Date
    08-07-2013
    Location
    Saudi Arabia
    MS-Off Ver
    Excel 2007 - 2010
    Posts
    73

    Re: Help with a loop through all sheets

    From the same macro, lets say that sometimes the macro don't find the "Resp. Co" if it doesnt find it I want it to delete the sheet

    Please Login or Register  to view this content.
    I tried with:

    Please Login or Register  to view this content.
    which is:
    Please Login or Register  to view this content.
    What Im doing wrong??

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Loop not going through different sheets
    By KeithMale in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2013, 06:57 PM
  2. [SOLVED] loop action through all sheets in workbook skipping certain sheets
    By sawa85sa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2013, 06:40 PM
  3. Loop through sheets
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-28-2011, 10:02 AM
  4. Loop for available sheets
    By rinch in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-20-2011, 09:40 AM
  5. Loop through 2 sheets
    By Treuz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-14-2009, 03:50 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1