LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default UDF Using Defined Name

Can someone please tell me how I can access the contents of a Defined Name in
a user defined function?

I have a page in a workbook with a number of "factors". I have, on a second
worksheet, a series of cells into which I have placed the UDF, with a few
parameters.

In some cases, the same factor is always used in the function, I do not wish
to pass that factor to the function, rather, just point at the defined name.
In the following

Public Function FTE(SRnum, SRfactor, RELnum, RELfactor)
FTE = ((SRnum * SRfactor) + (RELnum / 12 * RELfactor)) / 168
End Function

The factors SRfactor and RELfactor are fixed, and stored in a defined name
on another sheet. Rather than always passing these values, I would like to
simply point at them. I have tried a number of ways I have seen in books on
excel functions, etc, but they always result in a #Value error.

The defined name of these factors, on worksheet "Factors" are SRHours and
RELHours. How would I replace SRfactor and RELfactor to point at these
defined names?

Thanks!!!!
 
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
Run-time error '50290': Application-defined or object-defined erro Macro button Excel Discussion (Misc queries) 1 March 12th 09 10:59 AM
Runtime error 1004- application defined or object defined erro Novice Excel Programming 0 February 6th 06 09:34 PM
Runtime error 1004- application defined or object defined erro Novice Excel Programming 1 February 6th 06 09:33 PM
Runtime error 1004- application defined or object defined erro Jim Thomlinson[_5_] Excel Programming 0 February 6th 06 09:29 PM
Application-Defined or Object-Defined Error on simple code Fid[_2_] Excel Programming 1 July 21st 05 08:30 PM


All times are GMT +1. The time now is 01:33 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"