Excel Named Range - Worksheet Scope

Sep 16, 2013 at 2:16 PM
How do I create a named range in Excel with a worksheet scope and not a workbook scope? I have tried the following but both give a workbook scoped named range...
Excel.Range range = ...
range.Name = "some name";
Excel.Worksheet sheet =...
Excel.Range range = ...
sheet.Names.Add("some name", range);