Excel won't respond when using function IpSubnetVLookup #3
Description
Hello, first of all awesome script, thank you!! I have a table array of 1700 IPs to be matched against 7800 subnets and the function IpSubnetVLookup is hanging. My PC is an i7 with 32GB of RAM, but still takes a long time to calculate and even after that every time I scroll through the sheet it keeps calculating at a very slow pace and finally I have to terminate Excel because it becomes unresponsive. Do you have any ideas to fix this?