How to move a selection one cell up using VBA?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to move a selection one cell up using VBA?

11-19-2019, 07:42 AM

Debaser

Windows 7 64bit How to move a selection one cell up using VBA?

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")

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find last non empty cell (moving horizontally), then move one cell to the right	klutch	Word VBA	9	07-09-2018 06:16 PM
Move Selection to the next Column on a Page (Not a table)	GuitarForLife	Word VBA	7	02-09-2018 01:59 PM
extract time from a cell and move it to front of cell before text	ewso	Excel	20	03-19-2017 11:34 AM
Move the data at bottom cell to right side of the cell	kcyag91	Excel	1	01-28-2016 12:28 AM
Move data from 1 cell to another cell	Catalin.B	Excel	1	06-25-2011 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:58 PM.