Excel, Network
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