How to extend the range of user definied public function

[Villalobos]

Hello,

I would like to ask some help regardig user definied public function. In my public function there is a FORECAST formula but the range is not dynamic as I want.
I have attached the sample file.




Thanks in advance the help!

[Olly]

Changing your UDF so the input ranges are dynamic, simply turns it back into the FORECAST function. Why not just use Forecast in your worksheet?

[Villalobos]

Hello Olly,

Thank you for your attention. I just would like to develop my VBA knowledge, this is the reason why the FORECAST function in UDF.
Do you have any idea how should change the VBA code?