Sub yuwen()
Dim str1, str5, str
Dim ywx, cywx
Dim i, j
ywx = Worksheets("分数线").Cells(5, 5).Value
cywx = Worksheets("分数线").Cells(4, 5).Value - Worksheets("分数线").Cells(5, 5).Value
j = 1
For r = 4 To Worksheets("文科成绩册").UsedRange.Rows.Count
str1 = Worksheets("文科成绩册").Cells(r, 4).Value
str5 = Worksheets("文科成绩册").Cells(r, 5).Value + Worksheets("文科成绩册").Cells(r, 6).Value + Worksheets("文科成绩册").Cells(r, 7).Value + Worksheets("文科成绩册").Cells(r, 8).Value + Worksheets("文科成绩册").Cells(r, 9).Value
If str1 < ywx And str5 > cywx Then
str = Worksheets("文科成绩册").Cells(r, 3).Value
Worksheets("六缺一").Cells(j, 1).Value = str
j = j + 1
End If
Next
End Sub
提示类型不匹配
我下面的可以运行
Sub test()
Dim str
Dim i, j
i = 1
j = 1
For r = 1 To Worksheets("我").UsedRange.Rows.Count
For c = 1 To Worksheets("我").UsedRange.Columns.Count
str = Worksheets("我").Cells(r, c).Value
Worksheets("你").Cells(j, 1).Value = i
Worksheets("你").Cells(j, 2).Value = c
Worksheets("你").Cells(j, 3).Value = str
j = j + 1
Next
i = i + 1
Next
End Sub
我的这个就是工作表的,分数线和文科成绩册 是sheet的
追答可惜看不到原件
追问我把原件传给你
这是原件http://pan.baidu.com/s/1jGJqeVG
宏 在 文科成绩册下面