title: I don't want my Excel Add-In to return an array (instead I need a UDF to change other cells)
body: <p>I've created an Excel Add-In, and one of the functions of this Add-In, lets say <code>New_Years</code> currently takes in 2 years and outputs every New Years day between those 2 years as an array in Excel.  So <code>New_Years(2000,2002)</code> would return Jan 1st 2000, Jan 1st 2001, and Jan 1st 2002 in the last cell.</p>
  
  <p>The problem is that I have to know there are going to be 3 dates in that time, select 3 cells, enter my formula in the top cell, and then hit <code>Ctrl + Shift + Enter</code> to fill out the array.</p>
  
  <p>I use XLW version 5 to convert my C++ code to an .xll file.  I would really like it if there was some way I could just fill in one square with my formula, and Excel would fill in the squares below as needed with the appropriate dates.  Anyone know if this is possible?  Or impossible?</p>
  
  <p>Many thanks!</p>