different value for setting with breakpoint vs regular running code
Just a thought, and of course I maybe way off the mark if comprehending your
request.
Would a "Select Case" be of help, something along the lines like:
If Not ("MyCondition") Is Nothing Then
Select Case True
Case (MyCondition_1)
With ActiveChart.Axes(xlValue, xlSecondary)
.MinimumScale = ActiveChart.Axes(xlValue,
xlPrimary).MinimumScale
.MaximumScale = ActiveChart.Axes(xlValue,
xlPrimary).MaximumScale
End With
Case (MyCondition_2)
With ActiveChart.Axes(xlValue, xlPrimary)
.MinimumScale = ActiveChart.Axes(xlValue,
xlSecondary).MinimumScale
.MaximumScale = ActiveChart.Axes(xlValue,
xlSecondary).MaximumScale
End With
End Select
End IF
HTH
Mick
|