network calculations in Excel 2010

i need often to calculate network addresses, subnet-masks/bits, Hosts and more. For this i wrote this script Network.bas, which you can implement in your Excel file or your Default template book.xltm:

i implemented this functions:

  • NetworkCalculate
    • Add or subract from an IP-Address:
  • NetworkBitsToSubnetmask
  • NetworkBroadCastAddress
  • NetworkClientHighestAddress
  • NetworkClientLowestAddress
  • NetworkClientRange
  • NetworkSubnetAddress
  • NetworkSubnetMaskToBits
  • NetworkBitsToSubnetMask