|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> [e5].Address Then Exit Sub
If Len([e5]) Then
If [e5] = "32.5R" Then
[b5] = "复合硅酸盐水泥"
arr = Sheet1.[a1].CurrentRegion
ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
For i = 8 To UBound(arr) - 1
k = k + 1
For j = 1 To UBound(arr, 2)
brr(k, j) = arr(i, j)
Next
Next
End If
If [e5] = "42.5R" Then
[b5] = "普通硅酸盐水泥"
arr = Sheet3.[a1].CurrentRegion
ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
For i = 8 To UBound(arr) - 1
k = k + 1
For j = 1 To UBound(arr, 2)
brr(k, j) = arr(i, j)
Next
Next
End If
End If
[a8:d27].ClearContents
If k Then [a8:f9].Resize(k) = brr
End Sub |
评分
-
1
查看全部评分
-
|