Missing Numbers from a Range

Hello All

Hope one of you can help, I need to create a macro that can identify missing nos. from a range I.e
Range Missing no.
1 4
2 6
3
5
7

Thanks in advance