View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
c1802362[_2_] c1802362[_2_] is offline
external usenet poster
 
Posts: 65
Default another Vlookup question

Per/Dave -

Thanks - declaring the named range as a Range solved the problem.
Without any VBA documentation on VLookup, I used the excel
documentation as a guide. In excel, the range name in parentheses
declares the range. In VBA, the range has to be declared.

Anyway, much obliged, everything works wonderfully.

Art