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
