I have had to zip the attached document because it contains macros.
I think the VBA macros solve your problem. The Green Arrow icon on the Quick Access toolbar runs the relevant macro, CopyValidMACAddresses().
The macro tests the mac addresses to ensure that they are 12 characters long and consist entirely of A-Z, a-z or 0-9.
Hope this is what you wanted.
|