Here is an Excel VBA routine for converting a named range from Workbook level scope to Worksheet level scope.