View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MrShorty MrShorty is offline
external usenet poster
 
Posts: 1
Default Return array from worksheet function


Are you entering the function in only one cell, or are you selecting a
2x2 range before entering the function? As with Excel's built in
functions that return an array, you have to select the entire output
range when entering the function to get the entire output array
returned.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=562104