View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How do create a formula to add IP addresses?

"Bob Phillips" wrote:
Just drag and copy them down, Excel does it.


I shoulda remembered that myself. But on second thought, I
think Chip's suggestion of using a macro is the best idea because
it can be extended to cover the more general case of "incrementing
an IP address". The OP assumes that requires only incrementing
the last octet, which is the case for Class C IP addresses. But in
the case of a Class A, B and D IP addresses, incrementing 255
may carry over to the next octet. For example, the next address
after 1.2.3.255 is 1.2.4.0.