Microsoft Office Development and Consultancy
|Excel > Charts > VBA Code > Resizing||< Previous | Next >|
This works when any part of the chart is selcted
Aligning and Sizing
A ChartObject class has standard positional and sizing properties.
The following code resizes all ChartObjects on Sheet1 so they match the dimensions of the ChartObject named Chart 1
It also arranges the ChartObjects so they appear on after the other along the left of the worksheet.
|© Better Solutions Limited 15-Oct-2013||< Previous | Top | Next >|