View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Validate IP Address

On Fri, 11 Sep 2009 21:09:27 +0100, "RB Smissaert"
wrote:

Not sure I got the logic of IP addresses, but wouldn't something like this
be a lot faster?


It'd probably be faster. Mine was pretty quick to code since I have the
Regular Expression for IP addresses in my library. Also, except for my =isIP()
function, the others do not reject constructs with more than four octets.
--ron