Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 -- filk ----------------------------------------------------------------------- filky's Profile: http://www.excelforum.com/member.php...fo&userid=1180 View this thread: http://www.excelforum.com/showthread.php?threadid=26724 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User defined function | New Users to Excel | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
User defined function | Excel Programming | |||
User Defined Function | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |