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