Dear Barb,
It's not solving my problem.

Some other code pls.

Rgds,
Harsahd

"Barb Reinhardt" wrote:

How about something like this

Sub Test()
Dim WS As Worksheet
Dim WB As Workbook

Set WB = ActiveWorkbook

For Each WS In WB.Worksheets
If LCase(WS.Name) Like "nn*" Then
Call NNA
Call NNB
Call NNC
End If
Next WS

End Sub
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Harshad" wrote:

Dear Shane,
Thank you,
It's worrking.

But i want to know what code i should put so that macro NNA, NNB & NNC runs
on more than one Sheet namely NN1 to NN50.

Thanks in advance



"ShaneDevenshire" wrote:

Hi,

Sheets("Main").Activate

You can start the macro from any sheet but it will move the the Main sheet
if you put this line near the top of the macro. similar lines for all the
macros.

--
Thanks,
Shane Devenshire


"Harshad" wrote:

My workbook cointain54 sheets.
Sheet names in ascending order a Main, Content, Micro, Help, NN1,
NN2,....,NN50.
I have macros name: Main, Content, Micro1, Micro2, Help, NNA, NNB, NNC.
I want to run specific macro on specific sheet as shown below, evenif what
ever sheet is active.
Macro Main & Content on sheet Main & Content respectively.
Macro Micro1 & Micro2 one by one on Sheet Micro.
Macro Help on sheet Help.
Macro NNA,NNB,NNC one by one on Sheet NN1 to Sheet NN50

Please sugest some code which i can put at the starting of specific macro so
that it can run.