Sort across a single row
 

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.

Sort across a single row
 

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.

--
Regards,
Tom Ogilvy


"Scott P" wrote:

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.

Sort across a single row
 

Thank you very much, Tom. This is a big help.

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"Scott P" wrote:

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.