Yes, I did not know that was what it was doing, you are correct. That is a
method that I was not aware. Thank you.

"ryguy7272" wrote:

This looks like a user defined function (UDF Function)
=CELLCOLORINDEX()

I don't use Excel 2007, so I don't know fort sure, but I'd be surprised if
it is a built-in function in the new version.

So, go to the Excel workbook where the function is working correctly, then
hit Alt+F11 on your keyboard. You should see a module in the window that
opens. Open the module, if it isn't opened already. Copy the syntax from
that module into a new module in your new workbook. Then, call the function
in your new workbook. That should work for you...

Regards,
Ryan---

--
RyGuy


"Steven" wrote:

=CELLCOLORINDEX(C39,FALSE)

I have this in an old file and it returns a value.

I tried it in a new file becuase I cant remember how it works and I get the
$Name# returned.

Why is that.

Thank you,

Steven