Parse the address getDimensionDataSourceString returns for a range.
getDimensionDataSourceString
The address, such as Sheet1!$A$2:$A$9.
Sheet1!$A$2:$A$9
The range, or null for anything but one rectangle on one named worksheet: a list of values, several areas, or another workbook's range.
null
Parse the address
getDimensionDataSourceStringreturns for a range.