I'm working on a project where I need to populate some excel named ranges with some data. However I'm receiving the addresses of these named ranges as strings and not `Microsoft.Office.Tools.Excel.NamedRange`. The strings look something like `Sheet1_A1_D1`. How can I convert these strings to a NamedRange object? are there any predefined methods? Thanks for all your help!