Trying to add row and complete Sequence

[awarmplace]

I have an excel list that has an incomplete sequence and I want excel to evaluate each row and where there is a number missing in the sequence I want excel to add a row and the missing number. Example

8185
8214
8216
8217
8220

I need for excel to take the the out of sequence list above and add a row for each missing number, it should look like the following:

8185
8186
8187
8188
8189
8190
8191
8192
8193
8194
8195
8196
8197
8198
8199
8200
8201
8202
8203
8204
8205
8206
8207
8208
8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220

 

[SkipVought]

Hi,

Did you miss my post several hours ago in the other forum you posted this question in???

alternatively, you can do this without code.

On a New Sheet...

A1: =MAX(Sheet1!A:A)
A2: =A1+1

run it down to the MAX value

which assumed your list is in Sheet1 column A

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]