Thread: incrementing
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
luuthur luuthur is offline
external usenet poster
 
Posts: 2
Default incrementing

OMG, TYSM this is going to save alot of time... i hope to learn more about
these programs.. thanks again..


"Roger Govier" wrote:

Hi

Just type the first one in a cell, then the second one in the cell
beneath.
Mark both cells, and use the fill handle at the bottom right of the pair
of cells to fill down as far as you wish.
The end number will step up sequentially.

--
Regards

Roger Govier


"luuthur" wrote in message
...
i would like to make a list of IP's going from 172.16.1.0-172.16.1.254,
is
there a formula that will increment this to save me time? i need to
type
about 3000+ addresses. please help..