Sort Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been working on a macro to resort an alphanumeric list to avoid:

A1
A10
A2

to rather result in:

A1
A2
A10

I have a macro that inserts a leading zero, then I manually sort, then
another macro removes the zero. I'd like to combine them into a single
subroutine, but I don't know how to sort the currently selected range.

Can anyone help?

Thank you.
Sprinks
 
Selection.Sort ...

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Real-time sorting 11
Alpha sorting (with a twist...?) 3
writing a sort macro 2
Sort by column, not range 1
how do I sort a list a1 to a15, b1 to b15 etc 2
How to sort AlphaNumeric Data sequentially with spaces 4
Alphanumeric Sort 3
sort question 1

Back
Top