View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
None None is offline
external usenet poster
 
Posts: 15
Default Moving rows with out removing from range


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.