Use the format I posted as you can use only numbers for both row and column.
VB Code:
  1. oCell1 = [i]Sheet1[/i].Cells(1, 1)

  2. oCell2 = [i]Sheet1[/i].Cells(2, 1)

  3. [i]Sheet1.[/i]Range(oCell1, oCell2).Select()

  4. '...

  5. 'But you dont need to "Select" the cell as it slows down 

  6. 'your code and also because you can just reference the cell.

  7.  
  8. file = [i]Sheet1.[/i]Range(oCell1, oCell2).Value