| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link Data from several colums into a single one and sort | Excel Discussion (Misc queries) | |||
| CAN YOU ALPHA SORT IN A SINGLE CELL? | Excel Discussion (Misc queries) | |||
| Single formula to 'sort' a list onto a second sheet? | Excel Worksheet Functions | |||
| Sort across a single row | Excel Programming | |||
| sort data in a single cell? | Excel Programming | |||
Linear Mode
