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