Excel 2000 (although would like to know if 97 is any different), VBA 6
On the worksheet, it is easy
Where measure is a named Range.
I thought I could do something like this in a VBA Sub/function:-
Debug.Print CStr(WorksheetFunction.Match(Q3, ActiveWorkbook.Names("Measure").RefersToRange.Areas(1).Address, 0))
(WRONG - Get "Unable to find match property in WorksheetFunction class")
Object browser says Match is in the WorksheetFunction class.
Set WF = CreateObject("Excel.WorksheetFunction")
Set WF = New Excel.WorksheetFunction
...do not seem to create the object.
Is it possible to call the functions in the WorksheetFunction class??? Others must have needed to do this before now, how did you solve it? Go to a empty cell and change the formula on the fly - messy but a possibility??