Thread: .Paste
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default .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?