+ Reply to Thread
Results 1 to 3 of 3

How to apply macro on particular sheets

  1. #1
    Registered User
    Join Date
    01-17-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    25

    How to apply macro on particular sheets

    Hi,
    i want to apply a macro for all sheets that start with "MCC ENTRY" and "MCC EXIT"
    i.e. MCC ENTRY 1, MCC ENTRY 2, MCC ENTRY 3, etc. & MCC EXIT 1, MCC EXIT 2, MCC EXIT 3, ETC.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: How to apply macro on particular sheets

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    01-17-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: How to apply macro on particular sheets

    Hi,
    although the code looks good, it does not work with me, neither in upper nor lower case, i have also applied the below code and it didn't work. please advise.

    Please Login or Register  to view this content.
    Quote Originally Posted by :) Sixthsense :) View Post
    Please Login or Register  to view this content.
    Last edited by Haikal_; 01-19-2014 at 10:07 AM. Reason: typo error

  4. #4
    Registered User
    Join Date
    01-17-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    25

    Red face Re: How to apply macro on particular sheets

    it is now working after adding:
    Ws.Activate

    the code is:

    Please Login or Register  to view this content.

+ 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. I want to apply this macro for all sheets...How?
    By AbhijeetM in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-13-2013, 09:13 AM
  2. Apply Macro to a number of sheets
    By sush23 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-01-2012, 07:32 PM
  3. Apply macro to all sheets
    By Costasg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2011, 01:09 PM
  4. Apply macro to all sheets!!!
    By Sirishgreen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-26-2007, 05:23 AM
  5. apply a macro to all sheets except for a certain sheet
    By minrufeng in forum Excel General
    Replies: 4
    Last Post: 02-22-2006, 10:55 AM

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