|
本帖最后由 jinzikun 于 2017-1-23 14:16 编辑
各位大师,我手头有个年级成绩汇总表,想设计一个班级成绩查询系统,只要输入班级名,指定区域就会显示该班级的成绩表,具体代码不知如何写,请多多帮助或指教。
- Sub 查询()
- Dim FindRng As Range
- bj = [c2] & "班"
- nj = Left(bj, 1) '年级名
- sname = Mid("一二三四五六", nj, 1) & "年级汇总表" '通过年级名确定工作表名
- [a4:m100].ClearContents
- With Sheets(sname)
- Set FindRng = .UsedRange.Find(bj)
- If FindRng Is Nothing Then
- MsgBox sname & "中查无此班": Exit Sub
- Else
- r1 = FindRng.Row
- r2 = .Cells(r1 + 1, 2).End(xlDown).Row
- .Cells(r1 + 1, 1).Resize(r2 - r1, 13).Copy Sheets(1).[a4]
- End If
- End With
- End Sub
复制代码
|
|