Looping for each worksheet across two workbooks-CodePudding

Home > other > Looping for each worksheet across two workbooks

Looping for each worksheet across two workbooks

Time：06-30

I want to basically run a for loop that looks like

for each worksheet in workbook1 and workbook2

CodePudding user response：

You can set up two loops

Dim WB As Variant, WS As Variant
For Each WB In Array(Workbook1, Workbook2)
    For Each WS In WB.Worksheets