I have the following marco which sorts each column on its own, I wanted to extend it to also sort by cell color when needed. When I go to run the marco I receive an Compile error: Syntax error.

This is the individual column sort which works great.

Please Login or Register  to view this content.
This is the modified Color Column Sort which is receiving the Syntax error:

Please Login or Register  to view this content.
Thanks all for any help you can give me.

TonyM