| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel2000: UDF's parameter as cell range OR array
Hi
How to create an UDF which can have as parameter either the cell range or an array, i.e both syntaxes in examples below will work: =MyFunction(A2,B2,OtherSheet!$A$2:$A$7) or =MyFunction(A2,B2,{2;3;4;5;6;7}) Thanks in advance -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel2000:How to link Print Area with a named range | Excel Worksheet Functions | |||
| Defining new function with cell range parameter | Excel Programming | |||
| Printing date range in excel2000 | Excel Programming | |||
| Excel2000: Reading Named Range value from VBA | Excel Programming | |||
| Excel2000: finding last row of used range | Excel Programming | |||
Threaded Mode
