Excel

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
  •