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

M

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
 
M

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
 
M

micmacuk

I have found the solution....

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