VBA Code to sort data ranges individually

[roymunoz03]

Hi,

I need to create a macro to sort multiple data ranges individually at once, but I need to use custom order by cell color.

For example my range is J7:M10 so I need to sort the three rows individually by cell color. Could you recommend me some VBA code for this?

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=579587

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).