Check in the Help File under ImportData, there are four options for Excel including NamedRange and R1C1 syntax..
geoImportAccessQuery
DataSourceMoniker specifies an Access query.
geoImportAccessTable
DataSourceMoniker specifies an Access table. Default.
geoImportExcelA1
DataSourceMoniker specifies Excel A1 syntax.
Default.geoImportExcelNamedRange
DataSourceMoniker specifies an Excel named range.
geoImportExcelR1C1
DataSourceMoniker specifies Excel R1C1 syntax.
geoImportExcelSheet
DataSourceMoniker specifies an Excel worksheet. Default.
geoImportFirstRowIsHeadings
First row of the file contains field names. Default.
geoImportFirstRowNotHeadings
First row of the file does not contain field names.
There are also some examples in there, e.g.
Code:
'Excel sheet R1C1 reference
szconn = objApp.Path & "\Samples\Sales.xls!Sheet1!R1C1:R3C9"
Set oDS = .ImportData(szconn, , geoCountryUnitedStates, , geoImportExcelR1C1)