Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can someone help me with this? The first sort works fine but the second sort
gives me an errormessage: The sort reference is not valid. Make sure that it's within the data you want to sort, and the first Sort Box isn't the same of Blank. What does that mean? Sheets("Sheet1").Select ClastRow = ActiveSheet.Cells(Rows.Count, "D").End(xlUp).Row ActiveSheet.Range("D2:G" & ClastRow).Select Selection.Sort Key1:=Range("D2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("D2").Select Sheets("BulkUploadReport 1 ").Select ClastRow = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row ActiveSheet.Range("A2:O" & ClastRow).Select Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("B2").Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting by code | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
sorting code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
12 digit code sorting | Excel Worksheet Functions |