sorting dynamically

[geebee]

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("C810856").Sort Key1:=Range("D8"), Order1:=xlDescending

thanks in advance,
geebee