The source and Destination of a copy have to be the same size object

Copying a worksheet you need after or before othewise you get a new workbook


1) worksheets("Sheet1").copy 'creates a new workbook with 1 sheet. No
Paste required

2) worksheets("Sheet1").copy after:=sheets(1) 'no paste required

3) Columns("A").Copy
Columns("D").Paste

4) Rows(1).Copy
Rows(6).Paste

5) Range("A1:D10").Copy
Range("D101").Paste or Range("A1011:D110")

6) Range("A1:D1").Copy
Range("A2:A10").Paste

Note the paste can be the first cell of the destination or the entire
destination

"Bishop" wrote:

I have the following code:

With Sheets("DirectorCopy")
.Paste

Why doesn't this work? Keep getting Object doesn't support property or
method. I've tried:

.Cells.Paste
.Paste
.ActiveWorksheet.Paste
.Paste("A1")
.ActiveSheet.Paste Destination:=Worksheets("DirectorCopy").Range("A1" )
(which is how the help file says to do it)

None of these work.

what will work here?