Excel formula to complete missing gaps of IP addresses range
Posted on 2011-09-26
I have an excel file which has 1 column, data starts in A2 cell (A1=heading)
lets say there's a range of:
126.96.36.199 - 188.8.131.52 in ascending order
I would like somehow to fill in the missing gaps in the correct position, for example:
<automatically insert 184.108.40.206>
<automatically insert 220.127.116.11>
<automatically insert 18.104.22.168>
I would like to get a complete solution / VBA script if possible.
Thanks a bunch.