Thread: Array UDF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dileepan Dileepan is offline
external usenet poster
 
Posts: 1
Default 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