How to Sort Merged cells for worksheet?

K

KMBrady

I'm looking for away to sort rows using VBA with merged cells.
Columns A - C

Rows in column A are merged (Value defines a group of rows)
Rows in B,C are not merged, and are associated with the Meged group in
column A
I'm trying to sort by the value in column A, and keep all associated rows
together

Example:
Group 1
A1:A5 are merged with a value of '1' (value of A1)
Column B1:C5 are not merged
Group 2
A6:A15 are merged with a value of '3' (value of A6)
Column B6:C15 are not merged
Group 3
A16:A20 are merged with a value of '2' (value of A16)
Column B16:C20 are not merged
Group 4 through Group x
same structure but column A could be any value

How can I sort the values in column A and keep the rows in each group
together?

Any thoughts are welcome
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
Sorting Multiple Tables 1
Code to sort rows getting hung up by merged cells 0
Strip out certain rows that have merged cells 2
Fixing text wrap in merged cells 1
Copy/Transpose into a matrix of merged cells. Use Offset formula orVBA ? 2
wildly varying execution speeds - is it the code? 3
any ideas why execution speed varies? 5

Top