Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Obviously my code above is wrong, but it should give you an idea of what I'm looking to accomplish. Thanks for any help! Also I attached a sample spreadsheet.
Private Sub AutoFill() Dim LastRowInA As Long Dim r As Range Set r = Range("Match of left(Main!B2") LastRowInA = Range("A1048576").End(xlUp).Row r.AutoFill Destination:=Range("Match of left(Main!B2" & LastRowInA) End Sub
Join the community of 500,000 technology professionals and ask your questions.