I have an Excel spreadsheet with a fragmented range and can't find it using Worksheets.GetRangeByName or Worksheets.GetNamedRanges.
On a Worksheet called "Config", this is what my range looks like: =Config!$B$13:$C$13;Config!$B$15:$C$16v
Using MS Office Interop 14, I can access this range. The range would be divided into Areas, each Area with a set of coordinates.
Are fragmented ranges not supported or is there another way to access these types of ranges? Any suggestions if it isn't supported?