Hi, and thank you for your time.
I've got the following code that lists all the named ranges in my workbook.
I need to loop through these and set their value:
i.e. Named Range = xrange
Need to set the value of xrange to =Data!$D$18:$D$26
NameCollection ranges = wd.Workbook.Worksheets.Names;
string blah = string.Empty;
for (int i = 0; i < ranges.Count; i++)
if (ranges[i].GetRange() != null)
blah = ranges[i].GetRange().GetEnumerator.ToString();
lbRecent.Items.Add(new ListItem(ranges[i].Text + " ::: " + blah));
This message was posted using Page2Forum from Name.GetRanges Method - Aspose.Cells for .NET