title: How to get next IP in range from Excel
body: <p>I know there has to be a way:</p>
  
  <p>I need help getting any hot excel module/trick/script/macro that would look at a range of IPs and give me the next address up? 
  e.g. 
  (192.168.1.128) --> (192.168.1.129)</p>
  
  <p>Not sure i need sub nets, but will throw it out there as well.
  ( 192.168.1.255) --> ( 192.168.2.1)</p>
  
  <p>I bet is has to be done with vbscript and quick and dirty tutorials on how to implement this would be stellar</p>
  
  <p>Thanks in advance~</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>excel column D has 192.168.1.1 which was manually entered</p>
  
  <p>excel column E should have 192.168.1.2</p>
  
  <p>I want to avoid someone manually entering that</p>
  
  <p>what is the best way to accomplish this? </p>