None of those will work unless the specified sheet is the active sheet. (Partial qualification 1 won't ever work as it's invalid syntax)

General comment: if you mean to refer to a specific workbook and worksheet, do so explicitly - even if that's just Activesheet. In my opinion, you should never use Range (or Cells) without a qualifier, since the code may or may not work properly depending on where it is and which sheet is active.