User Defined Function - Title

  • Thread starter Thread starter filky
  • Start date Start date
F

filky

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

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

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

Thank
 
filky

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

=CellColorIndex(A3)

without the workbook name.
 
Back
Top