View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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