View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
אלי אלי is offline
external usenet poster
 
Posts: 67
Default sorting multiple-area selection

Dear friends

Is it possible to select in one column only those cells with data and to
sort them with code? for example:

A1
A2 2
A3 1
A4 3
A5
A6 6
A7 5

And I want it to be:
A1
A2 1
A3 2
A4 3
A5
A6 5
A7 6

Thanks in advance for your help.