VBA Code on multipe sheets

[teranprasanna]

Hi All,

I need to run a specific code on multiple worksheets (Only for selected worksheets) within same workbook.

Any suggestions?

Appreciate your support.

Thanks!

[HansV]

For example:

Code: Select all

Sub Example()
    Dim w As Worksheet
    For Each w In Worksheets(Array("ThisSheet", "ThatSheet", "OtherSheet"))
        ' Do something with w
    Next w
End Sub

You should not assume that w is the active sheet in the part between For Each w and Next w unless you use w/Select, but that is usually less efficient.

[teranprasanna]

Thanks, it works!