Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am copying and pasting some entries (entire rows, one at a time)
from one worksheet (NewDataWS) to another worksheet (ErrorWS) in the same workbook. This code works fine: NewDataWS.Cells(i, FirstNameCol).EntireRow.Copy ErrorWS.Paste Destination:=ErrorWS.Range("A" & ErrorRow) I want to place another value (not in the source row) in the destination worksheet for each row, as I process it. However, when I change the second line to start at Column "B", like below: ErrorWS.Paste Destination:=ErrorWS.Range("B" & ErrorRow) I get the following runtime error: "Runtime error 1004 The information cannot be pasted because the Copy area and the paste area are not the same size and shape. . . . " Since I am just specifying the starting cell, I do not understand why I get this. Do you? Thanks in advance, Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
JB Bates' Runtime Error 1004 problem | Excel Discussion (Misc queries) | |||
runtime error '1004' application or object defined error. Please help | Excel Programming | |||
Copy paste to another Workbook, Error 1004 | Excel Programming | |||
Copy Paste not working from Add-in - Error 1004 | Excel Programming | |||
runtime error 1004 paste method of worksheet class failed | Excel Programming |