Hi

In a workbook I have a named range Weeks, which contains string values in
format "yyyy.ww". What is the best way to find the position of string value
XWeek (which equals p.e. to "2006.01") in range Weeks using VBA?

I can get the range definition
ThisWorkbook.Names("Weeks")
, but I haven't find a way to search in it.
Of-course I can read the range into VBA as an array, add a couple of array
search functions I have written before for some other project, and search
this array, but maybe there is an easier way.


Thanks in advance

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )