lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I selected cells and I want to cut them and then paste them somewhere else. So I wrote the code below. The cut part is working but not the paste. Is that the way it should be done or there is better way? I am learning how to use Selection object. Any idea would be very much appreciated.
Sub cut_selection()
Application.Selection.Cut
End Sub
Sub paste_selection()
Application.Selection.Paste
End Sub
I selected cells and I want to cut them and then paste them somewhere else. So I wrote the code below. The cut part is working but not the paste. Is that the way it should be done or there is better way? I am learning how to use Selection object. Any idea would be very much appreciated.
Sub cut_selection()
Application.Selection.Cut
End Sub
Sub paste_selection()
Application.Selection.Paste
End Sub