Look at the second argument of the ColorIndex function
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| Thanks for the code but it seems to only work with cell formatting- not text
| formatting (font color) and I have a lot more of that.
|
| "Niek Otten" wrote:
|
| > Look here:
| >
| > http://xldynamic.com/source/xld.ColourCounter.html
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Is it possible to sort by cell color format or text color format? I tried to
| > | gather info by CELL but it always returns G .
| >
| >
| >
One follow-up. I can only seem to call the function if it's created in a
module within my current workbook. How can I create the function so it's
accessible each time I create a new workbook? I tried posting it in the
personal workbook, but if it's in there I can't call it (get the #NAME? error)
When using a UDF from Personal.xls you must preface it with the filename.
=Personal.xls!Function()
I prefer to place UDF's in an add-in.
No filename required
=Function() is sufficient.
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
