Non Consecutive Rows Sort Data With Multiple Ranges

**bdb1974** · 02-23-2010, 05:19 PM

Hi all,

Once again, I'm seeking some further assistance to an issue that I have yet to resolve.

I have several rows of data which I'd like to be able to sort by the info in column "A".
The data rows are not all consecutive. The range for which the data resides are:
Range("A25:A73,A85:A105,A145:A193"), When I sort I want my data to stay
within these limits/ranges.

Please Login or Register  to view this content.

Any help is appeciated .

Thanks,

BDB

**Leith Ross** · 02-23-2010, 06:06 PM

Hello BDB,

This macro should do it.

Please Login or Register  to view this content.

**bdb1974** · 02-24-2010, 06:50 PM

Thanks Leith for your assistance.

It appears that this sorts an indivdual column only w/o orientating the entire row.

Can you fix this so it sorts the entire row or for the range("A:H")?

Also, If I want to add another sort based on two columns, how would I do this?

I'd like to sort based on column B then on A.

Again thanks for all of your help.

Regards,

BDB

**Leith Ross** · 02-24-2010, 07:41 PM

Hello bdb,

I see the "H" in your post now. So the range would look like this...

Please Login or Register  to view this content.

**bdb1974** · 02-25-2010, 02:08 PM

Leith,

This is sorting each range with the RNG as a separate sort list.
Can the 3 ranges be sorted as a single list ? As if, there were no blank rows between them and w/o affecting/moving the blank rows in the sort ?

thanks,

BDB

**bdb1974** · 02-26-2010, 12:18 PM

Is there way to handle sorting two ranges as a single range?

**shg** · 02-26-2010, 12:29 PM

You could copy the several areas to a blank worksheet, do one contiguous sort, and then copy by area back to the original ranges.

**bdb1974** · 02-26-2010, 12:42 PM

I guess there is always a workaround solution.
I'm really more interested in having it done "INSITU" if possible.
If its not possible with/ Excel or with VBA coding, I'd like to know that too.

Thanks SHG.

BDB

**bdb1974** · 02-26-2010, 04:31 PM

Here's the work around I came up with to use.

Please Login or Register  to view this content.

Basically I'm removing the rows between the separate ranges and removing the formatting
of the cells.

I perform the sort by the selected column, then resplit or add the rows and the formatting back to the cells.

I was really hoping there would be a more straight forward method of doing this w/o having to remove rows or formats from the sheet.

Regards,

BDB