finding the scale on a chart
 

I know how to set the scale on a chart with vba code but how would I find
(using vba code) what the scale is set to in a cahrt?

finding the scale on a chart
 

Hi,

This will return the maximum value of the value axis.

msgbox activechart.Axes(xlvalue).maximumscale

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Scott" wrote in message
...
I know how to set the scale on a chart with vba code but how would I find
(using vba code) what the scale is set to in a cahrt?