Hi I have a macro that copies Column H in Sheet1 into Column F in Sheet2, it works fine as intended, able to copy and paste all the values, however the range of Column F is selected in Sheet1 after running the macro and i don't know why or how to remedy it. Below is the macro i have, could any kind soul advice?
Sub Button1_Click()
Dim wsCopy As Worksheet
Dim wsDest As Worksheet
Dim lCopyLastRow As Long
Dim lDestLastRow As Long
Set wsCopy = Worksheets("Sheet1")
Set wsDest = Worksheets("Sheet2")
lCopyLastRow = wsCopy.Cells(wsCopy.Rows.Count, "H").End(xlUp).Row
lDestLastRow = wsDest.Cells(wsDest.Rows.Count, "F").End(xlUp).Offset(1).Row
wsDest.Range("F2:F" & lDestLastRow).ClearContents
wsCopy.Range("H7:H" & lCopyLastRow).Copy wsDest.Range("F2")
End Sub
