How can we access named ranges by using XlsIO?

1 min read

You can access the named range through workbook. It can be accessed through its name or its index and add text to it or access the address of the referred range without having to access the worksheet. Please refer the below code snippet.

workbook.Names["A1"].RefersToRange.Text = "XlsIO";

workbook.Names("A1").RefersToRange.Text = "XlsIO"

Did you find this information helpful?

Yes

Comments (0)

How can we access named ranges by using XlsIO?

Access denied