Copy method of Range class failed

[mssbass]

What am I doing wrong here?

Sub Appenddata()



Dim lastrow1 As Long, lastrow2 As Long
Dim ws1 As Worksheet, ws2 As Worksheet
Dim WB As Workbook


Set WB = ThisWorkbook
Set ws1 = WB.Sheets("ACT")
Set ws2 = WB.Sheets("OFC")


lastrow1 = ws1.Range("A" & Rows.Count).End(xlUp).Row
lastrow2 = ws2.Range("A" & Rows.Count).End(xlUp).Row + 1


ws2.Range("A2:D" & lastrow2).Copy ws1.Range("A" & lastrow1)
ws2.Range("E2:E" & lastrow2).Copy ws1.Range("F" & lastrow1)
ws2.Range("F2:F" & lastrow2).Copy ws1.Range("H" & lastrow1)
ws2.Range("G2:G" & lastrow2).Copy ws1.Range("J" & lastrow1)
ws2.Range("H2:H" & lastrow2).Copy ws1.Range("L" & lastrow1)
ws2.Range("I2:J" & lastrow2).Copy ws1.Range("N" & lastrow1)


End Sub

 

[sheetspread]

ws2.Range("A2:D" & lastrow2).Copy Destination:= ws1.Range("A" & lastrow1) any better?

 

[Fluff]

There's nothing wrong with the code that I can see.
Although I think the +1 should be on lastrow1 not lastrow2.

What error are you getting?
Do you have sheet protection on?
Do you have merged cells?

 

[mssbass]

Thank you - I don't have sheet protection on or merged cells. I'm simply trying to copy certain columns of data from 1 table on 1 worksheet to the bottom of another table on a different worksheet.

The code highlights this in yellow: ws2.Range("A2:D" & lastrow2).Copy ws1.Range("A" & lastrow1)

Error was: "Copy method of Range class failed" - Excel then locked up. Now, when I closed out and re-opened, it seems to run through the code.... I just upgraded to Excel 2016. I've noticed my Excel is 32 bit but my operating system is 64 bit. Could this have something to do with this issue?

 

[Fluff]

Glad it's sorted & thanks for the feedback.

I've noticed my Excel is 32 bit but my operating system is 64 bit. Could this have something to do with this issue?

No, this won't affect it.