Where can I learn more about the syntax that Mirabeau used at the beginning of this thread? The word paste is never used, but the code pastes everything to a new sheet. I'd like to figure out how to PasteSpecial:=xlPasteColumnWidths with this code.
With Sheets.Add(after:=Sheets(sname))
Sheets(sname).Cells(1).Resize(rws, cls).Copy .Cells(1)
.Cells(1).Resize(rws, cls).Sort .Cells(cc), 2, Header:=xlYes