title: Getting vba script to automatically calculate a range from a cell with multiple values
body: <p>I am new to vba and have an issue that I hope someone can help me out with and please explain what each step is for me grasp an understanding.  I want to make it where I take a set of values in one cell and paste it in the other the thing about it is these are ip addresses with specific masks.  Say for instance a cell has 192.168.1.0/30, I want it to go to the next sheet and automatically convert the range to be 192.168.1.0 and 192.168.1.1 below it and onward.  I need it to detect whether or not it is /29 or /28 also and automatically fill in the column until it reaches the amount of addresses that are for the range. Also there might be instances where it will look like this:</p>
  
  <p>192.168.1.0/30
  192.168.5.25
  192.168.6.120/28,192.168.6.0/29</p>
  
  <p>and I want it to be like this basically on the next sheet</p>
  
  <p>192.168.1.0
  192.168.1.1
  192.168.1.2
  192.168.1.3
  192.168.5.25
  192.168.6.120
  192.168.6.121
  192.168.6.122
  192.168.6.123
  192.168.6.124
  192.168.6.125
  192.168.6.126
  192.168.6.127
  192.168.6.128
  192.168.6.129
  192.168.6.130
  192.168.6.131
  192.168.6.132
  192.168.6.133
  192.168.6.134
  192.168.6.135
  192.168.6.0
  192.168.6.1
  192.168.6.2
  192.168.6.3
  192.168.6.4
  192.168.6.5
  192.168.6.6
  192.168.6.7</p>
  
  <p>This will be down one column on an alternate sheet.  I do want to thank you for your help in advance.</p>