Error in formula !! and I can't see why

[micmacuk]

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

[John James]

U is the 21st column and AG is the 33rd column

[micmacuk]

Thanks for your message James,

sorry I didn't check exactly the this but is was as an example only.
The problem I have is that VBA bugs on the second formula

[micmacuk]

I have found the solution....

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