User Defined Function - Title

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
 
D

Dick Kusleika

filky

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

=CellColorIndex(A3)

without the workbook name.
 

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.

Ask a Question

Similar Threads

User defined function 1
User Defined function - second posting 4
Passing a named range into a user defined function 2
User-defined function clitch ... 6
How to call a function of an user defined DLL from Excel? 3
OPENFILENAME A P I. User cancels ? 1
How to take advantage of user defined properties immediately after Outlook Message Itemtype conversi 2
User-defined data type; Error: Only User-defined types... 1

Top