filky

If you put the UDF in an Add-in, you can reference the function directly.

=CellColorIndex(A3)

without the workbook name.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"filky" wrote in message
...

I have created a user defined function (based on a script provided
courtesy of exceltip) and am left with a formulae as follows.

='Causeway Financials Project - Resource Schedule - Sep 04
V10.1.4.xls'!CellColorIndex.CellColorIndex(A3)

Is it possible to make the function name more recognisable instead of
'Causeway Financials Project - Resource Schedule - Sep 04
V10.1.4.xls'?

Thanks


--
filky
------------------------------------------------------------------------
filky's Profile:
http://www.excelforum.com/member.php...o&userid=11801
View this thread: http://www.excelforum.com/showthread...hreadid=267246