| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort a row of strings, some containing blanks
I am trying to sort a row, some cells contains strings and others
blanks. Range = "B18" to "AY18" The "SORT" below does nothing! Can anyone see why? --------- Private Sub Workbook_Open() Dim OldRange As Range Set OldRange = Worksheets("Variables").Range("FA_budget_lines") OldRange.Sort 'Key1:=OldRange(1), Order1:=xlAscending, _ Header:=xlNo, Orientation:=xlSortColumns 'some more code goes here... End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Formula to sort two strings | Excel Worksheet Functions | |||
| HOW DO YOU SORT EXCEL FILE WITH BLANKS | Excel Worksheet Functions | |||
| How do I sort a list that contains blanks that I want to keep? | Excel Discussion (Misc queries) | |||
| Can I remove blanks from a range without using sort? | Excel Discussion (Misc queries) | |||
| how do I reset the default sort order in excel xp back to blanks . | Excel Discussion (Misc queries) | |||
Threaded Mode
