Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array UDF
Hi,
I have an array UDF that displays value from the first cell into all the cells in the array range. With MsgBox I know the values are getting computed correctly. Please let me know what I am doing wrong. The relevant portion of the UDF is given below. ====================================== Function rkArray(dataArray As Range, K As Integer) As Variant ..... statements ..... ReDim rk(K) ..... statements computing rk array rkArray = rk End Function ====================================== -- Dileepan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) |