CC10
asked on
run macro for selected sheets in workbook
Hello,
the macro below runs for all the sheets in Wb"A".
Can one change it so that it runs for only for the selected sheets with names sheet1, sheet2, sheet6 and sheet10
Thanks,
CC
Sub processAllSheets()
Dim iSheet As Worksheet
For Each iSheet In Workbooks("A.xlsx").Sheets
Call CopyRowsByDate(iSheet.Name )
Next iSheet
End Sub
the macro below runs for all the sheets in Wb"A".
Can one change it so that it runs for only for the selected sheets with names sheet1, sheet2, sheet6 and sheet10
Thanks,
CC
Sub processAllSheets()
Dim iSheet As Worksheet
For Each iSheet In Workbooks("A.xlsx").Sheets
Call CopyRowsByDate(iSheet.Name
Next iSheet
End Sub
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I was unaware that the A grade was the default and awarded the B grade as I thought it was a relatively simple and uncomplicated question.
If you wish I can change it to an A grade but how do I do that.
CC
If you wish I can change it to an A grade but how do I do that.
CC
Thank you.
Open in new window
You would want to do something like:
Open in new window