|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Set SHK = Worksheets("考勤表")
- Set SHJ = Worksheets("结果")
- SHJ.Range("A2:AZ1048576").ClearContents
-
- X = 1
- For I = 5 To SHK.Range("A1048576").End(3).Row
- If InStr(Replace(SHK.Cells(I, 1).Value, " ", ""), "工号") > 0 Then
- Rem 提示信息,在状态栏显示
- Application.StatusBar = "当前姓名是:" & SHK.Cells(I, 11).Value
- DoEvents
-
- X = X + 1
- SHJ.Cells(X, 1).Value = SHK.Cells(I, 21).Value
- SHJ.Cells(X, 2).Value = SHK.Cells(I, 3).Value
- SHJ.Cells(X, 3).Value = SHK.Cells(I, 11).Value
-
- For ICOL = 1 To 31
- If SHK.Cells(I + 1, ICOL).Value <> "" Then
- A = SHK.Cells(I, ICOL).Value
- STRX = GetRegStr(SHK.Cells(I + 1, ICOL).Value, "[0-9]{2,2}[:][0-9]{2,2}", 0)
- ARX = Split(STRX, "|")
- STRX = ARX(0)
- If UBound(ARX) > 0 Then
- STRX = STRX & vbCrLf & ARX(UBound(ARX))
- End If
-
- SHJ.Cells(X, ICOL + 3).Value = STRX
- End If
- Next
- End If
- Next
复制代码 |
评分
-
1
查看全部评分
-
|