Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bob Phillips' Colour Counter
Hi Bob / All,
Thank you for all the great material that you contribute on the web-site and in the newsgroups. I have been using your colour counter method for awhile now and I love it. I just ran into a problem I was hoping you could help me with. I have a helper column set up to sort a range by font color with the formula "=colorindex(a1, true)" copied down some 150 rows or so. This works great. However, if I paste a "cut" selection into a new cell/row, I get a #value error in my helper column. The formula in the column has changed to "=colorindex(#Ref!,true)". This only happens if I paste a "cut" selection into the row/cell. If I paste a copied selection there is no problem. Have you / anybody seen this behaviour and can you help me out? Am I missing something silly? Thanks in advance. Dominic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can somebody explain to me how Bob Phillips' unique record counter works? | Excel Programming | |||
Bob Phillips | Excel Programming | |||
To: Bob Phillips | Excel Programming | |||
Bob Phillips | Excel Programming | |||
Bob Phillips | Excel Programming |