| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using defined name in UDF
I have a sheet with some defined names on it:
Name1 = A1:C1 when I type =Name1 in A5 it returns the value in A1. When I type =Name1 in C5 it returns the value in C1. Is there a way to replicate this behavior when passing these names to a UDF? My function work if the defined name is one cell but returns #value when the name is defined as above... I assume this is because my code is not able to except an array. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
| Application-Defined or object defined error 1004 When ran on exel97 but not 2003 | Excel Programming | |||
| Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
| Runtime error 1004- application defined or object defined erro | Excel Programming | |||
| Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Threaded Mode
