Skip to content

Instantly share code, notes, and snippets.

@hurss
Created September 5, 2017 05:39
Show Gist options
  • Save hurss/6fe94454a5bb51c0c51f0e3a26ecd256 to your computer and use it in GitHub Desktop.
Save hurss/6fe94454a5bb51c0c51f0e3a26ecd256 to your computer and use it in GitHub Desktop.
pasting all row elements with Excel VBA
Sub 매크로1()
'
' Excel 세로줄 붙여넣기
'
' 바로 가기 키: Ctrl+E
'
Selection.Copy
ActiveCell.Offset(1, 0).Select
Range(Selection, Selection.End(xlDown).Offset(-1, 0)).Select
ActiveSheet.Paste
Selection.End(xlDown).Select
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment