Code to run all the sheets on the right side of one specified sheet

[dennisli]

Hello everyone, I am back for more question:
How can run a loop for all the sheets on the right side of sheet tab named Target?
Appreciate.
DL

 

[AlphaFrog]

[color=darkblue]Sub[/color] Loop_Sheets_Right_of_Target()
    [color=darkblue]Dim[/color] i [color=darkblue]As[/color] [color=darkblue]Long[/color]
    [color=darkblue]For[/color] i = Worksheets("Target").Index + 1 [color=darkblue]To[/color] Worksheets.Count
        [color=green]'Do something here with Worksheets(i)[/color]
        MsgBox Worksheets(i).Name [color=green]'Example[/color]
    [color=darkblue]Next[/color] i
[color=darkblue]End[/color] [color=darkblue]Sub[/color]

 

[dennisli]

Thanks lot, have a good day.

 

[Smitty]

Dennis,

Please continue in your Original Thread.