One of a set of tools we're offering as a way of saying thank you for being a part of the community.
' get rid of unwanted results that do not contain str Dim ri As Long With UserForm2.ListBox1 For ri = .ListCount - 1 To 0 Step -1 If .List(ri, 8) <> str Or .List(ri, 9) <> str Then .RemoveItem ri End If Next End With
|VBA or Script to identify files which are duplicate in a folder||6||31|
|MS Excel Formula Help||3||32|
|Copy column before Column A using a macro||6||13|
|split user ID and domain name from email addresses using formula||3||15|