Sorting variable amounts of data

Hi, I am trying to write a macro that will look at a section of data, sort the data until it hits a blank cell and then move the newly sorted data to another location. Column C is random numbers for random sorting. The data is in column D. The data could range from 1 cell to 35 cells. I can't figure out how to make the sort variable, like I can the moving using the xlDown thing.

Here's what I have so far. It is currently showing C65:D87 because that's what ended up there when I recorded the macro. Thanks for any help on this!

Sub Macro9()
'
' Macro9 Macro
'

'
    range("C65:D65").Select
    range("D65:D65").Activate
    range(Selection, Selection.End(xlDown)).Select
    ActiveWorkbook.Worksheets("SkillCards").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("SkillCards").Sort.SortFields.Add Key:=range( _
        "C65:C87"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _
        xlSortNormal
    With ActiveWorkbook.Worksheets("SkillCards").Sort
        .SetRange range("C65:D87")
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
    range("D65").Select
    range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    range("D3").Select
    ActiveSheet.Paste
    range("D65").Select
    range(Selection, Selection.End(xlDown)).Select
    Application.CutCopyMode = False
    Selection.ClearContents
    range("D3").Select
End Sub

Note: I don't want to sort the whole 35 each time, because then with the random sorting, blanks will get sorted in and I want it to be contiguous when it gets moved to the new location. Unless there is some way to strip those blanks out at that time.

I hope I did this right.

Book12.xlsm

Hi:

I haven't looked at your excel file, but I think if you change "=range("C65:C87")" in your code to "Selection" it will work and become variable like you want.

That said, I think you should search the internet for examples of vba sorting code. Your code can be a lot more efficient and more manageable

Thank you, I will try that. I did try searching and couldn't find anything like what I want. I got that code from the macro recorder and then cleaned it up a little. I will see what else I can find though.