How to resize Excel displayable area display entire ChartArea
 

ello,

How can i programmatically change the excel displayable area such that it
can display the entire ChartArea on a worksheet.

This ALMOST works:
..
....Application.height = .ChartObjects(1).Chart.ChartArea.Height
....Application.width= .ChartObjects(1).Chart.ChartArea.Width
..

but doesn't display entire chart area because of the excel borders takes up
some of the space, as well as any toolbars that are active also take up space.

Thanks