I am trying to work out a VBA Sub that will list out all the months between 2 given years. For example; year range is A1:B2 and the Sub would list out the values as shown in A3:B__
<colgroup><col span="2"></colgroup><tbody>
</tbody>
Thanks in advance!!
Angusfire
A | B | |
1 | 1940 | 2018 |
2 | Year | Month |
3 | 1940 | 1 |
4 | 1940 | 2 |
5 | 1940 | 3 |
6 | 1940 | 4 |
7 | 1940 | 5 |
8 | 1940 | 6 |
9 | 1940 | 7 |
10 | 1940 | 8 |
11 | 1940 | 9 |
12 | 1940 | 10 |
13 | 1940 | 11 |
14 | 1940 | 12 |
15 | 1941 | 1 |
16 | 1941 | 2 |
17 | 1941 | 3 |
18 | 1941 | 4 |
19 | 1941 | 5 |
20 | 1941 | 6 |
21 | 1941 | 7 |
22 | 1941 | 8 |
23 | 1941 | 9 |
24 | 1941 | 10 |
25 | 1941 | 11 |
26 | 1941 | 12 |
27 | 1942 | 1 |
28 | 1942 | 2 |
29 | 1942 | 3 |
30 | 1942 | 4 |
31 | 1942 | 5 |
32 | 1942 | 6 |
33 | 1942 | 7 |
34 | 1942 | 8 |
35 | 1942 | 9 |
36 | 1942 | 10 |
37 | 1942 | 11 |
38 | 1942 | 12 |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
Thanks in advance!!
Angusfire