NM I got it to wok as I wanted it to. Thanks!

On Fri, 15 Dec 2006 11:47:21 -0500, None wrote:


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.