Moving rows with out removing from range

N

None

Rather than cut and paste rows, if there a way to select a range
of row and just move them up or down a set number of rows? The Pseudo
code below gives an idea of the context of what I am doing. The * line
is the one in question

Compare code
IF need to move up THEN
SELECT Rows for this Record.
*MOVE SELECTED Range up or down # of rows. *
END IF
Select Current

I asked this question previously and someone posted the Cut and
insert rows method; however, after testing it will not work. The rows
being moved are part of a ranged and cutting removes them from the
data range for that sheet. For some reason all the cells in the range
are removed as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top