Inserting rows for missing numbers in a column using VBA code

[ChetBelfast]

I am trying to get the a row inserted for all of the missing numbers in column E. There are over 1000 rows and there are randomly some numbers now in there. Just getting a row inserted will allow me to copy in data from another file to this, but the missing numbers are getting me and I can't seem to get a code to work with this many columns.

 

[RobP]

Glad we coud help.

cheers
Rob