Routine for sorting within a selection

  • Thread starter Thread starter Roel
  • Start date Start date
R

Roel

Hi,

Does anybody have a VBA routine that will do the following:

Say I have a column range (A1:A20) that has a list of names. Can it sort so
that you can move a name higher up? Like if Ann was in A1 and Bob was in A2,
a control will bring Bob up to A1, moving Ann down to A2.

This list will be fixed in size, so users can move names up and down the
list.

I know you can just manually copy and paste within the range, but that is
too much manipulating and prone to errors.

Help would be appreciated.

(Thank you! Thank you! Thank you!) x 100^100

Roel
 
Selection.Cut
Selection.Offset(-1).Insert xlDown

Of course, this would completely mess up any formula relationships.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify Sort Routine to inlcude All Data 2
Sort Routine Macro for Excel Worksheet 1
bug in sort routines 2
List sorting and macros 3
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Referring to a range that has been copied (Excel-VBA) 2
Loop in Excel 2
Routine too fast for Form to Update? 1

Back
Top