Copy/Paste Problem: Runtime error 1004
I just pasted the entire row, then added a cell:
NewDataWS.Cells(i, FirstNameCol).EntireRow.Copy
ErrorWS.Paste Destination:=ErrorWS.Range("A" & ErrorRow)
With ErrorWS.Cells(ErrorRow, 1)
.Insert Shift:=xlToRight
.Value = Message
End With
ErrorRow is a row counter to keep up with the next open row.
|