Sort by font color after sorting by separate variable

[RedWing]

Hi,

I've got the following problem:

I've sorted a column range according to row values, according to the target address matching the row name. After doing this sort, I now want to sort by font color (making the black font move to the rightmost) and again rearranging the column.

The code is as attached but I'm not getting anywhere with it (invalid qualifier error), if I remove the color bit it works fine just for values.

If anybody can tell me where I'm going wrong that would be much appreciated.

Please Login or Register  to view this content.

[RedWing]

Bump!. Still stuck on this!

Never mind, think I fixed it. Thanks anyway.

[Marcol]

I'd be surprised if your code works with 2003, as your profile suggests you need.

Your sort procedures are for 2007 and above and will fail with pre-2007 versions.