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


--
micmacuk
------------------------------------------------------------------------
micmacuk's Profile: http://www.excelforum.com/member.php...o&userid=33253
View this thread: http://www.excelforum.com/showthread...hreadid=533999

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533999

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
------------------------------------------------------------------------
micmacuk's Profile: http://www.excelforum.com/member.php...o&userid=33253
View this thread: http://www.excelforum.com/showthread...hreadid=533999

I have found the solution....

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


--
micmacuk
------------------------------------------------------------------------
micmacuk's Profile: http://www.excelforum.com/member.php...o&userid=33253
View this thread: http://www.excelforum.com/showthread...hreadid=533999