Insert columns with missing years using VBA in Excel

[mvaldez]

Dear experts.

I have been trying in various ways to insert the columns with the consecutive years that are missing in the row, but have not succeeded yet. The values of the years can vary and the distances of the cells between the years.

I would greatly appreciate your valuable help.

Before...

Macro to insert missing values in a range-Tov Meod.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1
2
3
4
5			2007	2008		2013				2015					2018					2020						2021
6
7
8
16

After...

Macro to insert missing values in a range-Tov Meod.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1
2
3
4
5			2007	2008	2009	2010	2011	2012	2013	2014			2015	2015				2018	2018				2020						2021
6
7
8
15

The years that are in red are the missing years and that must be added to the row.

Thanks in advance for your help.

 

[mvaldez]

Sorry.

After 2015 must be added 2016 and after 2018 must be added 2019.

Macro to insert missing values in a range-Tov Meod.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1	Macro: InsertYearsIA
2
3
4
5			2007	2008	2009	2010	2011	2012	2013	2014			2015	2016				2018	2019				2020						2021
6
7
15