Private Sub Worksheet_Activate()
Call test
End Sub
Sub test()
Dim i As Integer
Dim rng As Range
With ActiveSheet.ChartObjects("图表 4").Chart
.Axes(xlCategory).MaximumScale = [i33]
For i = 1 To 10
Set rng = Cells(15, i + 4)
If VBA.IsNumeric(rng) Then .SeriesCollection(2).Points(i).DataLabel.Characters.Text = rng Else Exit For
Next i
End With
End Sub
按F8运行,第二排命令运行到第七次就出现错误了,.SeriesCollection(2).Points(i).DataLabel.Characters.Text = rng Else为黄字,什么原因啊