In effect i want to fill it with all sheets from source workbook but exclude sheet1, sheet3 and sheets6, possible?
other way are welcome, sure.
Code: Select all
With Sourcewb
Set TheActiveWindow = ActiveWindow
Set TempWindow = .NewWindow
.Sheets(Array("ReadMe", "MailSheet(s)")).Copy
End With