xlt, yes:
I have one static IP assigned by my ISP that all the users share.
So when I am using this VBA code it is to ping only the users that are on my network.

Now if a user calls and says they can't get on the internet I can quickly determine if:
I am able to reach them via my network
IF yes THEN the problem is in their location
ELSE I need to run down my backhauls and APs to see they are up
OR I need to verify my internet connection is up

My spreedsheet has the IP for every CPE, Backhaul, & AP on my network, and the static IP we use to surf.

I should be in pretty good shape now.

As you have pointed out on so many occassions...
nothing is perfect... and I'm sure managment will ask for more.