Find missing numbers in unsorted list of numbers

Hello everyone
I have in column A >> range("A1:A5") some numbers which are not in a sequence

I searched and found a formula and I could edit it so as to get the missing numbers according to the min and max numbers
I need to convert this formula to vba code so as to get the same results as illustrated in Column C
Thanks advacned for any help

This should work

Please Login or Register  to view this content.

Excellent Mr. mikerickson

Thank you very much for this wonderful code
Just one point I need to get the results starting in E1 not in E2
Thanks advanced

Just one point I need to get the results starting in E1 not in E2
Thanks advanced

@YasserKhalil

Try to understand the code (learn from it).

Test it on your files (without saving it).

Do you find E1 in the code ?

Change this in E2 and test the code.

Please share the result on the forum.

I tested it and change E1 to E2 and get the same results starting from E2
and change E2 to E3 the same thing .. It is not related to the starting point ..
I mean the starting point of results

Then show us the excel file, what you have after running the macro.

Please also add the expected result in your file (manualy).

I could alter to get my results

Please Login or Register  to view this content.

Thanks a lot Mr. oeldere for offering help