I have to write some Access VBA to export data from an Access query into a specific range of cells in an Excel document that has several worksheets.

I am having trouble finding the right way to specify the **worksheet AND range**.

Here is what I have so far:

```
docmd.TransferSpreadsheet(TransferType:=acExport, SpreadsheetType:=acSpreadsheetTypeExcel8, TableName:=qry_Main, _
    FileName:="c:\test.xlsm", _
    HasFieldNames:=False, _
    Range:="Main!J9:J10")

```

The broken piece is `Range:="Main!J9:J10"`

What's the proper way to make this reference?