Strange:
Set sws = Sheets("Sheet1")
Sheets("Sheet1").Range("C10:C11").Copy
sws is 100% redundant
Sheets("Sheet2").Cells(10, .Columnscount)
to which object is .ColumnsCount referring ?
Besides .columnscount doesn't exist as range property.
In
Sheets("Sheet2").Cells(20, .ColumnsCount).Left(xlToLeft).Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
is 100% redundant.
Why not ?
Sheets("Sheet2").Cells(10,Columns.Count).Left(xlToLeft).Offset(0, 1).resize(2)=Sheets("Sheet1").Range("C10:C11").value