.Paste
paste means that there's something in the clipboard that has been copied
so what did you copy? and the error message say the object doesn't exist.
My guess is that you don't have a sheet named DirectorCopy? is there a 'y'
missing?? like DirectoryCopy
Option Explicit
Sub test()
Range("A1").Copy
With Sheets("DirectorCopy")
.Paste
End With
End Sub
"Bishop" wrote in message
...
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?
|