[RESOLVED] Sorting Excel File, By Colour of Row

[BCSteele]

Simple realy.

I've read an excel file with VB6, and due to certain criteria Have coloured Some Rows Red(3) Green(4) Blue(8) Yellow(6) scattered thru the spreadsheet, the remainder left default, this file is then saved.

Now the person I did this for wants to know if I can sort all the colors together.
He is not too bothered about sequence, but would like the greens ones first.

Is there anyway to do this? or is it easier to pass thru the file again , and using a blank column, set that to a value (for each colour) to allow me to sort on that?

Thanks in advance for your replies.

[Siddharth Rout]

Yes that would be easier.

The other way would be to loop through all line check if it is green in color. If it is then cut and insert(and not paste) it before 1st row. Repeat process till you have colors bunched together.

[BCSteele]

Thanks Kooldsid, thats what I thought.
It's just nice to have it confirmed!