[belajar-excel] Pindah satu cell ke bawah

[Yayan Ajah]

Assalamu'alaikum Wr. Wb


Dear B-Exeler & Master
Nubi mau tanya, gimana caranya agar pindah satu cell ke bawah lagi, berikut 
hasil record macro saya :


Sub Macro10()
'
' Macro10 Macro
'


'
    Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True
    Range("B7:B13").Select

    Application.CutCopyMode = False
    Selection.Delete Shift:=xlUp
    Selection.Copy
    Range("C2").Select
    Selection.End(xlDown).Select
End Sub


Wassalamu'alaikum Wr. Wb
Yayan