Sort across a single row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is it possible to use the Sort method in Excel VBA to sort values contained
in a single row? If so, how? I tried this by declaring a range (which
represents cells in a single row) and the applying the sort method to this
range and this does not work.

I know this works for sorting columns, but I want to sort left to right
across a row. Any assistance is appreciated.
 
select the row and do Data=>Sort, in the sort dialog, click the options
button and choose left to right.

If you need a macro, turn on the macro recorder while you do it manually.
 
Thank you very much, Tom. This is a big help.

Tom Ogilvy said:
select the row and do Data=>Sort, in the sort dialog, click the options
button and choose left to right.

If you need a macro, turn on the macro recorder while you do it manually.
Click to expand...
 
Back
Top