|
楼主 |
发表于 2014-5-14 12:54
|
显示全部楼层
Dim c1_team(1000, 5), taihao(30, 2), c2_team(60, 12) As Variant
Dim i, j, k, m, n, r, count, index1, index2, opp, opp1, opp2 As Integer
Dim playsum, playcount, teamsum, round, teamsumend, teamesc As Integer
Dim a, b As Double
Dim team1, team2 As String
Sheets("加3").Activate
round = 10
teamsum = Sheets("初始信息").Cells(2, 5)
playsum = Sheets("初始信息").Cells(3, 5)
playcount = Sheets("初始信息").Cells(4, 5)
teamesc = Sheets("初始信息").Cells(5, 5)
'统计
For i = 1 To Int((teamsum - teamesc) / 2) + 1
index1 = Sheets("加2").Cells(i + 3, 8)
index2 = Sheets("加2").Cells(i + 3, 9)
c1_team(index1, 1) = index2 '对手号
c1_team(index2, 1) = index1 '对手号
c1_team(index1, 2) = Sheets("加2").Cells(i + 3, 4) 'IMP
c1_team(index2, 2) = Sheets("加2").Cells(i + 3, 5) 'IMP
Next i
就这么一段
有的单元格是有数据的,就直接取值
多数空格的读后是空值
个别成了空字符串,难过 |
|