Chik wee (as Borat might say),
I'm wondering? is there any way that you can use a named range for the array in a vlookup that is done in VBA?
my named range is "Lists" and here's my code:
As ever people, thanks for looking & god bless this website or i'd be jobless!! lolFrmGet.TextBox1.Value = Application.WorksheetFunction.VLookup(Me.CbAgent.Value,***Named Range Here***, 2, True)
Bookmarks