I have a macro that moves sheets to a new workbook. However, the sheet names are hard coded into the code. For example:
WB.Sheets(Array("Al", "MS", "TX")).Move
WB.Sheets(Array("GA", "WV")).Move
Looking for a way to assign the sheet names to a variable so I can loop through the code vs. typing a unique line for all sheets.
WB.Sheets(Array("Al", "MS", "TX")).Move
WB.Sheets(Array("GA", "WV")).Move
Looking for a way to assign the sheet names to a variable so I can loop through the code vs. typing a unique line for all sheets.