Sorting rows by Color Index of cells

[DGillham]

I have a macro that compares to columns and highlights in Color Index 6 any duplicates (I don't want to delete them).

I do however want to sort the listing to isolate those cells that are Color Index 6. If anyone has any ideas how this is possible I'd greatly appreciate it.

Thanks

Darren

[VBA Noob]

Hi,

Ron's add-in might help

http://www.rondebruin.nl/easyfilter.htm


VBA Noob

[mridzuan]

The add-in does the filtering but not sorting by colour. Would be great if we could sort by colour.

[VBA Noob]

Yes it does. Last tab says color

VBA Noob

[DGillham]

Thanks very much!

Darren