Hello,
I want to copy sheet column A-Z only as below.
But compile error in named argument not found.
Any advice would be very much appreciated, thank you!For Each SourceSheet In SourceWorkbook.Sheets If LCase(SourceSheet.Name) = "ter" Or LCase(SourceSheet.Name) = "pop" Then SourceSheet.rang("AZ1:AZ1000000").Copy Before:=DestWorkbook.Sheets(DestWorkbook.Sheets.Count).Range("A1") End If Next SourceSheet
Bookmarks