Are you sure you're passing the proper cell references to the
ColorIndexOfCell function?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mk389" wrote in message
...

Hi,

I searched the forum and found this link
http://www.cpearson.com/excel/SortByColor.htm

to sort by color. However when I tried this function it gives
me weird
results. Yellow colored cells are numbered 2,45,6 etc. There is
very
little or no consistency in the results.

I was hoping someone could tell me what, if anything, I am
doing
wrong.

Regards
mk


--
mk389
------------------------------------------------------------------------
mk389's Profile:
http://www.excelforum.com/member.php...o&userid=15272
View this thread:
http://www.excelforum.com/showthread...hreadid=271186