Macro to sort multiple ranges in a single sheet

I need to make a macro that can select a range of cells and sorts by column A. Then select and sort the next range of cells. I was thinking that it could select based on cells in column D stopping to sort when it hits the highlighted blank cell, and then end the macro when it hits a blank unhighlighted cell. But I have no idea how to do that.

I'm uploading an example, this is how the sheet comes to me after exporting it from another program. As you can see, the size of each range varies, and the number of ranges varies as well. Any direction you could give would be helpful.

Thanks!

-Michael

Hi Michael

What is it you wish to end up with...the entire file sorted on Column A without the #N/A's? If so, simply do a filter on column A selecting only the #N/A's, delete them then sort.

If this is not what you're looking for, please explain further.

Hi Michael

See if this code does as you require. Let me know of issues.

Please Login or Register  to view this content.

Hi Michael

It won't be "tweaking" the code...I don't think. The #N/A cells were central to the proposed code. It'll probably require a rewrite...let me look at it.

Hi Michael

See if this does as you need. Let me know of issues.

Please Login or Register  to view this content.