Sorting With Cell Color Problem

[atakanyy]

Hello All,

I use this codes to sort my list from small to large. But it sort cells with filling colors.
I want to remain stable color of cells. Only contents.
What can I do for it?

Thanks...

Please Login or Register  to view this content.

[Mumps1]

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). Also include a manual mock-up of the expected results in another sheet.

[AlphaFrog]

This temporarily stores the colors in offset 100 columns, sorts, then restores the original colors.

Please Login or Register  to view this content.

[6StringJazzer]

What is your scheme for coloring the cells? One thing you could do without a VBA solution is to apply the colors based on absolute cell address using conditional formatting. You would need one rule for each different fill color. Sorting will not affect the "Applied To" range.
cfsort.JPG

[atakanyy]

This temporarily stores the colors in offset 100 columns, sorts, then restores the original colors.

Please Login or Register  to view this content.

Thanks... so much.
It works.