That's a first, Jooel admitting that he doesn't get a UDF. Maybe we should convert it into the next KiXGolf challenge? Make IsInIPRange smaller and remove the dependencies? [Big Grin]

Anyway, I think the UDF is straight-forward. However, I also wrote it [Wink]

First of all, please read TCP/IP Primer, Part I - IP Addresses to refresh your TCP/IP network knowledge.

Secondly, you'll need to include IsInIPRange and it's two dependiencies in your script as e.g. described in How to use UDFs .

Finally, you feed the IP address and an array of networkIDs/subnets into the UDF and you will get a return statement indicating whether the IP address is part of the network. Please implement the example provided in the function header to see how it works.
_________________________
There are two types of vessels, submarines and targets.