I am trying to make the following function call w/ MATCH
found = WorksheetFunction.Match(num_months, lookupRC(1), 0)
where lookupRC(1) is a string holding the named range that I need to use.
How can I represent this named range in such a way the MATCH function will accept it as the array_value discused in the MS help dialog.
found = WorksheetFunction.Match(num_months, lookupRC(1), 0)
where lookupRC(1) is a string holding the named range that I need to use.
How can I represent this named range in such a way the MATCH function will accept it as the array_value discused in the MS help dialog.