Truncating Ctrl-shift > Edit > CopyPicture

C

CLR

Hi All......

I have the following code,

Windows("ChucksDPMcalcsMasterC.xls").Activate
Application.GoTo Reference:="Print30230_2"
Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
Windows("MonthXX_XXXXXblank.xls").Activate
Sheets("Trends").Select
ActiveSheet.Paste

It's brute-force, but works fine, except that it truncates the range I am
trying to copy. The size of the range is only J100:AC148, but still it gets
truncated. It worked perfectly when I first designed it, but someone
increased some column widths within the range and then it started truncating,
without any notice except some of the data was missing. Does anyone know
what the limits are of this CopyPicture feature, both in height and width?

TIA
Vaya con Dios,
Chuck, CABGx3
 
L

Leith Ross

Hello Chuck,

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

Sincerely,
Leith Ros
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top