Excel Vba) 현재 셀에서 한줄내림 (activecell.offset(1,0).Select)

 

한줄 내리기 정말 간단하구만.

 

ActiveCell.Offset(1, 0).Select

 

 

 

 

Sub test1()

Range("R3").Select
Selection.End(xlDown).Select
bbb = ActiveCell.Row + 1
Range("r" & bbb).Select
MsgBox bbb
aaa = ActiveCell.Address(0, 0)
MsgBox aaa

End Sub