Creating Macro that detects what numbers/how many numbers are being skipped in a column

Hi guys,

I am trying to make a simple macro that will count and inform me of all the numbers that are skipped out of a column. I attached the file below. The column contains over 7k rows of mostly consecutive numbers with around 100 random numbers being skipped. There are also some blank spaces with "N/A" in them. I want it to completely ignore the N/A cells and tell how many/what numbers are missing.

Thanks in advanced!

Hi Marvin,

Thanks for the quick answer. You just blew my mind!

I wanted it in VGA because I was planning on adding onto another macro I have with it.
What I want it to do in the end is make a new row with a the actual numbers that are missing.

Thanks guys worked perfectly. Much appreciated.