it's normally used in this fashion:
Worksheets(1).Range(.Cells(1, 1), _.Cells(10, 10)).copy
Regards,
Simon