Sorting variable amounts of data

[oriecat]

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!

Please Login or Register  to view this content.

[oriecat]

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.

[AlvaroSiza]

Please post a sample workbook.

[oriecat]

I hope I did this right.

Book12.xlsm

[vandan_tanna]

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

[oriecat]

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.