Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving a range to end of list
Hi Everyone, What I would like to do is fill a range with misc. data. Then I wan to move that data to the end of a list. The range of cells the data i entered into is identical to the cells I want to move the data to. Th list is rather long and still growing so to automate this process woul be fantastic. I am very limited in my VB knowledge so any help woul be greatly appreciated. Thank you, Sinjin34 -- Sinjin34 ----------------------------------------------------------------------- Sinjin341's Profile: http://www.excelforum.com/member.php...fo&userid=1461 View this thread: http://www.excelforum.com/showthread.php?threadid=26244 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving a range to end of list
a simple demo
Sub moverange() Range("f12:g15").Cut Range("h1") End Sub -- Don Guillett SalesAid Software "Sinjin341" wrote in message ... Hi Everyone, What I would like to do is fill a range with misc. data. Then I want to move that data to the end of a list. The range of cells the data is entered into is identical to the cells I want to move the data to. The list is rather long and still growing so to automate this process would be fantastic. I am very limited in my VB knowledge so any help would be greatly appreciated. Thank you, Sinjin341 -- Sinjin341 ------------------------------------------------------------------------ Sinjin341's Profile: http://www.excelforum.com/member.php...o&userid=14616 View this thread: http://www.excelforum.com/showthread...hreadid=262444 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving range? | Excel Discussion (Misc queries) | |||
CODE 4 MOVING WITHIN A RANGE-TAB | Excel Discussion (Misc queries) | |||
sum with moving range | Excel Discussion (Misc queries) | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions |