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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Custom fill series||12||41|
|copy down array||24||36|
|VBA to trim leading and trailing spaces in all sheets of active workbook.||2||20|
|Combine Vlookup with indirect sheet reference||3||23|
Join the community of 500,000 technology professionals and ask your questions.