View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
joel[_691_] joel[_691_] is offline
external usenet poster
 
Posts: 1
Default Array formula does not calculate correctly when run from macro


I have generated UDF which I called from the worksheet using it like an
array formula. It only worked if I selected on the worksheet the exqact
size of data I wanted returned from the UDF. It didn't behave like a
stadnard function which calculates the size of data that was returned by
the UDF and then automatically puts all the data into the worksheet.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180681

Microsoft Office Help