Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default User Defined Function - Title


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 599
Default User Defined Function - Title

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User defined function linzhang426 New Users to Excel 4 October 10th 05 03:18 PM
User-defined data type; Error: Only User-defined types... tiger_PRM Excel Programming 1 July 18th 04 03:32 PM
User defined function Carlos Paez Excel Programming 1 June 24th 04 02:18 AM
User Defined Function Rutgers_Excels[_3_] Excel Programming 5 May 27th 04 06:59 PM
User-Defined Function pre-empting Built-in Function? How to undo???? MarWun Excel Programming 1 August 6th 03 09:31 PM


All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"