good day
i have the following code to paste data in the first open line in a different sheet and it works great
Code:Dim lst As Long
WSIM.Range("P2:T2").Copy
With Sheets("Result")
lst = .Range("A" & Rows.Count).End(xlUp).Row + 1
.Range("A" & lst).PasteSpecial xlPasteColumnWidths
.Range("A" & lst).PasteSpecial xlPasteValues
WSIM.Range("P2:T2").Clear
End With
how can this code be changed to rather paste the data in the first open column in the other sheet