good day
i have the following code to paste data in the first open line in a different sheet and it works great
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