PDA

View Full Version : Solved: Determining size of chart area?



starsky
04-01-2010, 03:30 AM
Hi,

A quickie I hope. Is it possible to quickly determine the size of a chart that has been created so that this size can be incorporated into a chart creation macro?

Many thanks.

Bob Phillips
04-01-2010, 03:41 AM
With ActiveSheet.ChartObjects("Chart 1")

MsgBox .Width & " - " & .Height
End With

starsky
04-01-2010, 04:56 AM
Super, thanks xld.