Hi Leith.....

Thanks for the response, but in this case the "rejection" takes place even
befpre the destination is determined. Without VBA, if I just highlight the
area and do Ctrl-Shift Edit CopyPicture, I get the error message
announcing the truncation.....

Vaya con Dios,
Chuck, CABGx3



"Leith Ross" wrote:


Hello Chuck,

When Excel pastes data from the source to the destination, the cells
must match in size. Since someone increased the column widths in the
original range "Print30230_2" , then the destination range "Trends"
needs to be changed as well. Otherwise, Excel will truncate the data
being pasted.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=379027