Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I use UDF in an array formula?
Is it possible to use my own functions in an array formula? Is there a
special way I need to code such a function? I've tried writing it so that it accepts a variant array as a parameter, but it doesn't seem to work when I use it in an array formula. For example: Function MonthStart(ADate) Dim i As Integer If IsArray(ADate) Then For i = LBound(ADate) To UBound(ADate) ADate(i) = DateSerial(Year(ADate(i)), Month(ADate(i)), 1) Next MonthStart = ADate Else MonthStart = DateSerial(Year(ADate), Month(ADate), 1) End If End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Find specific value in array of array formula | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions |