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
|