Thread
: [Solved]
How to move a selection one cell up using VBA?
View Single Post
11-19-2019, 07:42 AM
Debaser
Windows 7 64bit
Office 2010 32bit
Competent Performer
Join Date: Oct 2015
Location: UK
Posts: 221
You need to resize as well as offset:
Code:
Selection.Offset(-1, 0).Resize(Selection.Rows.Count - 1).Copy Range("E5")
Debaser
View Public Profile
Find all posts by Debaser