Writing Concise VBA

Hi all,

As a novice in VBA, I was hoping to get some tips on writing more concise code. I have uploaded a sample file with a clunky subroutine I wrote, which I believe must be able to be written more efficiently using loops and novel conventions.
The code executes as I intend it to, but since I plan to continue adding functionality to this routine, I wanted to start down the 'right' path. Any suggestions would be greatly appreciated.

The intention of the code is to make forecasts based on historical data.

Thank you

Thank you Erwin, I will give your suggestion a go and see if I can implement!

Erwin, this has helped me immensely in my understanding. Thank you for your kindness!

Originally Posted by Eastw00d

furthermore, you have to declare this only once:

Please Login or Register  to view this content.

is also Year1

The Forecast_ETS function that I am using requires datatype double. Could I use Year1 or would I need to first convert it to a double?

That makes a lot of sense. The Locals window is very helpful too. Thanks for all the advice.