Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sorting dynamically
hi,
i am trying to dynamically sort a column, but the column is bveing sorted in DESC order. the problem is that there are some values of "no data" in a column with mostly numbers or percentages in it. i want the "no data" values to appear at the bottom of the sorted column after it is sorted in DESC order. how can i do this with code? i currently have: Range("C8:D10856").Sort Key1:=Range("D8"), Order1:=xlDescending thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Is It Possible To Dynamically Name Series? | Charts and Charting in Excel | |||
Dynamically sorting a range | Excel Programming | |||
Get Tab Name to Input Dynamically | Excel Programming | |||
Getting handle to Row # dynamically | Excel Discussion (Misc queries) |