Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncating Ctrl-shift Edit CopyPicture
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncating Ctrl-shift Edit CopyPicture
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 -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=37902 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncating Ctrl-shift Edit CopyPicture
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
F9, Shift+F9, Ctrl+Alt+F9 etc | Excel Discussion (Misc queries) | |||
shift option ctrl etc | Excel Discussion (Misc queries) | |||
Shift-Ctrl-DownArrow | Excel Discussion (Misc queries) | |||
CTRL+SHIFT+END | Excel Programming | |||
What does CTRL-ALT-SHIFT-F4 do? | Excel Programming |