A bit messy but this worked,thanks

"smartin" wrote in message
...
Clubsprint wrote:
We ban external networks fom access to our net and I'm trying to set up
aspreadsheet to help me identify single addresses when I get queries
about if someone is blocked. I've set up a spreqadsheet of the banned
networks and I want to autofill the stat and end address of the sub/super
nets. So that it loooks somewhat like this

Name ,Address , Mask , Start ,End
bantimewarner,207.250.0.0,255.255.0.0,207.250.0.1, 207.250.255.254

bannigeria216,216.133.174.0,255.255.255.0,216.133. 174.1,216.133.174.254

What I need is the formula to get the start and end addresses from the IP
and mask and what format do I set the cells to?


If you don't mind using about 30 helper columns here is a kludgy solution
for you:

http://vfdrake.home.comcast.net/file...calculator.xls

This makes heavy use of Harlan Grove's binary math formulae (which can be
viewed he
http://groups.google.com/group/micro...9693728f1559b6 )