Need some help with my macro (see below).
I have two sheets 1) ap modified 2) gl download

it's merging the two sheets together. however, it's pasting over the last row of data.
For example, gl download has data from row 4 to row 100
The Macro is pasting data from ap modified starting in row 100 of gl download instead of row 101.

how can i correct this? thanks!



Sub C_Merge()
Dim w1 As Worksheet, w2 As Worksheet
Set w1 = Sheets("ap modified")
Set w2 = Sheets("gl download")
Dim lr1 As Long, lr2 As Long
lr1 = w1.Range("A" & Rows.Count).End(xlUp).Row
lr2 = w2.Range("A" & Rows.Count).End(xlUp).Row

Application.ScreenUpdating = False
w1.Range("A4:U" & lr1).Copy w2.Range("A" & lr2)
Application.CutCopyMode = False
Application.ScreenUpdating = True
MsgBox "Task Completed!"
End Sub