RE Define Named Range.

[Guest]

I need to programmatically redefine a named range (normally created On the
Insert menu, point to Name, and then click Define. Type the name e.g.
MyTable, select the range and then click OK.) in an excel file.
I need to change the range from e.g. A118 to A11.

How can this be done in C#? If you don't know C#, VB is ok too.

 

[Guest]

I usually just do something like this in VBA

ActiveWorkbook.Names.Add "SampleName", "=$A$1:$D$1"


if SampleName doesn't exist yet, it creates it. If it already exists, then
it gets overwritten with the new reference.

 

[Guest]

I don't seem to see any Names property of Excel._Workbook.

 

[Guest]

Sorry, I'm a VB guy.

FWIW, this worked with VB.NET. I have the Excel 11 Object Library.


Imports Microsoft.Office.Interop

Module Module1
Sub Main()
Dim xlapp As New Excel.Application
Dim xlwb As Excel.Workbook
xlapp.Visible = True
xlwb = xlapp.Workbooks.Add
xlwb.Names.Add("SampleName", "=$A$1:$D$1")
End Sub
End Module