Creating a UDF to show a trend to the minimum point in a range

I am trying to write a UDF to give a result based on the the =TREND() function in Excel 2003. This should take the defined range and given the fixed start point, should calculate the trend using the data to the minimum point only. Below is the code I have so far.

Please Login or Register  to view this content.

Using the data (see below) and a to date of 29/01/2010 with this code I get the answer 3061.506, however if I manually select the range to the minimum point and use the =TREND() formula, I get the result 3087.098.

Please Login or Register  to view this content.

Thanks in advance for any help.

Here's the file

Thanks for your help