Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving rows with out removing from range
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from one worksheet to another whilst removing the data | Excel Discussion (Misc queries) | |||
Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
Finding criteria and removing matching rows (Range issue?) | Excel Programming | |||
Removing 1st four rows from a range | Excel Programming | |||
Removing Empty Rows and selecting Specific Rows | Excel Programming |