I am using the following script to move a row from one sheet to another.
Dim rng As Range
Dim intCols As Integer
Dim introw As Integer
Set rng = ActiveCell.CurrentRegion
intCols = rng.Columns.Count
introw = ActiveCell.Row
Range(Cells(introw, 1), Cells(introw, intCols)).Copy
Range(Cells(introw, 1), Cells(introw, intCols)).Delete xlShiftUp
Set rng = Nothing
Issue is in Ln14, it overwrites what is there in the destination sheet (LogArchived) in A7. How do I change this so it inserts and pushes what is on LogArchived sheet down at A7? It would be great if I could select more than one row on the Target sheet (TaskTracker) in shift down however many rows were selected. This way I could do more than one row at a time. Please advise and thanks.