For i = 1 To Rs.RecordCount
For j = 1 To flexyz.Cols - 1
flexyz.Row = i '选择第I行
flexyz.Col = j
If i / 2 = Int(i / 2) Then '判断是单是双
flexyz.CellBackColor = RGB(224, 248, 224) '双行的底色
Else
flexyz.CellBackColor = RGB(240, 248, 224) '单行的底色
End If
Next j
Next i
错在哪里了
怎么显示不出来?