Macro: Need help modifying macro, pasting over a row of data

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

Hi,

Try:

w1.Range("A4:U" & lr1).Copy w2.Range("A" & lr2 + 1)

In the future please add CODE TAGS. See the forum rules for instructions.

Lewis

it worked! thanks guys. i'll abide by the rules next time, thanks for letting me know.