Hello and thanks ahead for your help. I have a row of data that is CF
to turn red when true. Then I would like to sort this row to put
uncolored cells to the bottom of the list. I have gone to Chip Pearsons
sorting CF Colors Page and have tried ColorOfCF and ColorIndexOfCF and
allways I get #NAME?. When I enter =ColorOfCF($A$1,FALSE) into
theformula bar for B1, the Formula box pops up and shows all entries
resuls correct (no errors) but at the bottom it shows "undefined"
and the resuls show nothing (results= ), so when I click the OK
Button the cell shows "#NAME?" I've placed the codes in my Sheet1
Code Box, this is the sheet I'm using to test these codes, Only A1 has
a CF in it at this time.If I can get this to work I will enter data
thru A10 and fill down B1 to B10 and there should be numbers in these
B1:B10 cell if there is color in the corresponding cells. Right?
What am I doing Wrong? Thanks again John