ExcelBanter - Sort by Color

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sort by Color (https://www.excelbanter.com/excel-programming/314277-sort-color.html)

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 weir
results. Yellow colored cells are numbered 2,45,6 etc. There is ver
little or no consistency in the results.

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

Regards
m

--
mk38
-----------------------------------------------------------------------
mk389's Profile: http://www.excelforum.com/member.php...fo&userid=1527
View this thread: http://www.excelforum.com/showthread.php?threadid=27118

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