Li Chen wrote:
...
>    cells = sheets.cells("A1:A5")

Try:
   cells = sheets.Range("A1:A5")


Cheers
Chris