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)


"Sprinks" wrote in message
...
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