Is there anyway when doing vlookup through VBA to include the sourcelist (Ranges) in the VBA code itself without having to put any information in the sheet?
I found this code by Benvolio in the Mr Excel Message Board Archive:
Sub Example_of_Vlookup()
Dim lookFor As Range
Dim rng As Range
Dim...