Thread: Sort Macro
View Single Post
  #1   Report Post  
Sprinks
 
Posts: n/a
Default Sort Macro

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