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,