<div>
Great. This did the trick. Thank you very much for your professional support. Regards, Andreas
</div>


Great. This did the trick. Thank you very much for your professional support. Regards, Andreas

<div>
<div class="content wysiwyg-content">
Dear Experts: <br />
<br />
I would like to retrieve the width and height of the first chart in a MsgBox ...<br />
&nbsp; &nbsp; W = ActiveSheet.ChartObjects(1<wbr />).Width<br />
&nbsp; &nbsp; H = ActiveSheet.ChartObjects(1<wbr />).Height<br />
<br />
The measurements are regrettably displayed in Points, but I would like to show the measurements in centimeters rounded to two decimal places after the decimal point. <br />
How is this achieved? <br />
<br />
Help is much appreciated, thank you very much in advance, <br />
<br />
Regards, Andreas
</div>
</div>


Dear Experts: 

I would like to retrieve the width and height of the first chart in a MsgBox ...
    W = ActiveSheet.ChartObjects(1).Width
    H = ActiveSheet.ChartObjects(1).Height

The measurements are regrettably displayed in Points, but I would like to show the measurements in centimeters rounded to two decimal places after the decimal point. 
How is this achieved? 

Help is much appreciated, thank you very much in advance, 

Regards, Andreas

PointsToCentimeters VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.