Microsoft Office Tutorials and References
In Depth Information
‘Position the PivotChart so its top left corner
‘occupies cell H23, a few rows below the PivotTable.
ActiveChart.Parent.Left = Range(“H23”).Left
ActiveChart.Parent.Top = Range(“H23”).Top
‘Deselect the PivotChart.
‘Turn on ScreenUpdating.
Application.ScreenUpdating = True
End Sub
Press Alt+Q to return to your worksheet and test your macro. Figure 15-23 shows what the
worksheet should look like with the PivotChart added right where it was specified in VBA.
figurE 15-23
To view the video that accompanies this lesson, please select Lesson 15, available
at the following website: .
Search JabSto ::

Custom Search