Run Macro In Specific Sheet Range

[jackgan]

I have my template workbook with sheet tab as following:

\Summary/\Report/\Contact 1/\Contact 2/\Contact 3/\Contact 4/\Contact 5/\Note/

And I have one macro to run and only want to run in the specific sheet as below:

\Summary/\Report/\Contact 1/\Contact 2/\Contact 3/\Contact 4/\Contact 5/\Note/

The sheet name for contact 1 to 5 is varies means it can be change to any name based on different job. How should I write my macro in order to do that with one macro?

[mikeTRON]

Please Login or Register  to view this content.

[jackgan]

Never thought about that approach but how do I call my macro with that?

[jackgan]

I have my code as follow:

Please Login or Register  to view this content.

How should I modify my code so that when the macro end it will return to where I start my macro?

[jackgan]

I finally figure it out from other forum and below is my quote.

Please Login or Register  to view this content.

Reference:
http://www.excelforum.com/excel-form...ter-macro.html
http://www.mrexcel.com/forum/excel-q...ific-ones.html
http://www.mrexcel.com/forum/excel-q...pt-sheet1.html

[mikeTRON]

Yeah sometimes instead of trying to identify what TO do work to it can be easier to pick what to NOT do work to.

I would suggest you declare the 2 sheets as strings then define them and call them with the variable instead. It just makes it more tidy and easier to change in the future instead of looking for all the places you have something hardcoded like that.[Obviously you can change the variable names to whatever makes the most intuitive sense to you]

Please Login or Register  to view this content.

I am glad you figured it out. If it is solved go ahead and mark it solved and if you have any other questions just post up on the forum.