Results 1 to 21 of 21

A way to make a macro work on multiple sheets

Threaded View

  1. #16
    Registered User
    Join Date
    10-21-2012
    Location
    qatar
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: A way to make a macro work on multiple sheets

    Try this:

    Sub excludesheets()
       for i=1 to worksheets.count
          if sheets(i).name<> "Enter name of  1^ sheet to exclude" and sheets(i).name<>"Enter name of 2^ sheet to exclude" then
             sheets(i).select
             call Part2_SAP
          endif
       next i
    end sub

    Moderator Edit:

    Welcome to the forum, pippo12345.

    Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
    Thanks.
    Last edited by Cutter; 10-21-2012 at 12:36 PM. Reason: Added code tags

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