Hello,
I am struggling with trying to get my macro to go to each individual sheet and call (run) another macro
Dim ary As Variant
Dim sht As Variant
With Sheets("SheetsToRun")
ary = .Range("B1", .Range("B" & Rows.Count).End(xlUp)).Value
End With
For Each sht In ary...