Charlotte E. expressed precisely :
I have a named range on a worksheet, called 'TableRange'.
Making a vlookup in a worksheet formula will be like this
=VLOOKUP(F17,TableRange,2,1)
How to do this in VBA???
D = Application.Vlookup(cVal,"TableRange",2,1)
...doesn't work :-(
TIA
CE
D = Application.WorksheetFunction.VLookup(cVal, "TableRange",2)
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc