Share via

Paste values into next blank row VBA

Anonymous
2014-07-17T13:17:33+00:00

I have this code recorded but need it to paste in the next empty row in their respective columns starting from row 4. However I need the macro to only paste up to row 13. I also need these to paste values into the selected range. 

Sub trial_2()

'

    Range("B7").Select

    Selection.Copy

    Range("K4").Select

    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

        :=False, Transpose:=False

    Range("B8").Select

    Application.CutCopyMode = False

    Selection.Copy

    Range("L4").Select

    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

        :=False, Transpose:=False

    Range("A11").Select

    Application.CutCopyMode = False

    Selection.Copy

    Range("M4").Select

    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

        :=False, Transpose:=False

End Sub

Any help appreciated. Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments