Microsoft Office Tutorials and References
In Depth Information
Step-by-Step
‘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.
Range(“A1”).Select
‘Turn on ScreenUpdating.
Application.ScreenUpdating = True
End Sub
15.
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: www.wrox.com/go/excelvba .
Search JabSto ::




Custom Search