software

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(quot;WeekDataquot;).Range(quot;U500:AG540quot;).Copy Destination:=ActiveCell

Sheets(quot;WeekDataquot;).Range(Cells(500, 20), Cells(540, 32)).Copy
Destination:=ActiveCell

Any Idea ?

Cheers
Francois--
micmacuk
------------------------------------------------------------------------
micmacuk's Profile: www.excelforum.com/member.php...oamp;userid=33253
View this thread: www.excelforum.com/showthread...hreadid=533999
U is the 21st column and AG is the 33rd column--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: 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: www.excelforum.com/member.php...oamp;userid=33253
View this thread: www.excelforum.com/showthread...hreadid=533999
I have found the solution....

Sheets(quot;WeekDataquot;).Range(Sheets(quot;WeekDataquot;).Cells( 500, 20),
Sheets(quot;WeekDataquot;).Cells(540, 32)).Copy Destination:=ActiveCell--
micmacuk
------------------------------------------------------------------------
micmacuk's Profile: www.excelforum.com/member.php...oamp;userid=33253
View this thread: www.excelforum.com/showthread...hreadid=533999