vba code

[Paul]

I need to retrieve the maximum scale value from an active
excel chart and set a variable equal to that scale value.

can someone help me with the vba code to retrieve this
property value???

 

[Don Guillett]

Please do not re-post the same question within 2 hours. See your other post.