View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steven Sinclair Steven Sinclair is offline
external usenet poster
 
Posts: 21
Default Column Order Reversal...

I have a column of 1000 items.

I would like to be able to "reverse" the current order of the column, but
cannot use the sort feature as I have numbers mixed with text. Every time I
attempt to use the sort feature, everything is all messed up.

So if I have this...

a
1
2
b
3
4
5
c

I need this...

c
5
4
3
b
2
1
a

How can I accomplish this programmatically?

Thanx.