Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Application-Defined or Object-Defined Error on simple code | Excel Programming |