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

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