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???