| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sort multiple rows in excel
I vote for Bernie's suggestion.
"Bernie Deitrick" wrote: jsmith, Select all your cells, then run a macro like this, assuming you want each row to be sorted on its own.... HTH, Bernie MS Excel MVP Sub TryNow() Dim myRow As Range For Each myRow In Selection.Rows myRow.Sort myRow.Cells(1), xlDescending, header:=xlNo, Orientation:=xlSortRows Next myRow End Sub "jsmith@nisltd" wrote in message ... I have a spreadsheet with 7 columns wide with a large number of rows and I need to sort the data in the rows. I can do it for each individual row but, this time consuming and could do with knowing if there is any way to sort a couple of hundred rows. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Multiple Excel versions. | Excel Discussion (Misc queries) | |||
| Some rows sort incorrectly in Excel. How do I correct the problem. | Excel Worksheet Functions | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| how do I insert multiple rows in excel after every row of data | Excel Discussion (Misc queries) | |||
Threaded Mode
