Hello,

Could someone tells me why the 1st line works and not the 2nd. I thought it was the same.
Never the lest to say that I need to use the second format.

Sheets("WeekData").Range("U500:AG540").Copy Destination:=ActiveCell

Sheets("WeekData").Range(Cells(500, 20), Cells(540, 32)).Copy Destination:=ActiveCell

Any Idea ?

Cheers
Francois