For Each, Next
I have the following macro than contains another macro:
Sub MonthList()
Dim wks As Worksheet
For Each wks In Worksheets
OtherMacro
Next wks
End Sub
However, when i run it, OtherMacro (a list of months) only
get executed in the active worksheet. What am i doing
wrong?
regards
|