Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
In a VBA routine a selected ranges in Excel (2003) is copied and paste in PowerPoint. The routine runs a loop with an number of entities. A number of rows and columns in the selected area are grouped on a lower level and only cells on level1 are visiblebefore CopyPicture.It works OK apart from one problem. The problems is that some of the columns, furthest to the right, are not included in the PowerPoint shape. It can vary a little some what which user runs the routine. Below extract from the code. Thanks in advance for any help. "Worksheets("Forecast Report").Range(Cells(11, 25), Cells(53, 51)).CopyPicture pptapp.Activate pptapp.Presentations(ppfilename).Slides(pp2).Shape s.Paste shn = pptapp.Presentations(ppfilename).Slides(pp2).Shape s.Count ppheigt = 320 Set Shape4 = pptapp.Presentations(ppfilename).Slides(pp2).Shape s(shn) With Shape4 .Name = compl & ppcur & "shapetable" .Top = 75 .Left = 20 .Height = ppheigt End With " |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CopyPicture from Excel Range to Power Point | Excel Programming | |||
Range CopyPicture() | Charts and Charting in Excel | |||
CopyPicture ????? | Charts and Charting in Excel | |||
CopyPicture ????? | Excel Programming | |||
CopyPicture | Excel Programming |