|
- Sub test()
- Dim rngTemp As Range
- Dim i As Long
- Dim strFind As String
- strFind = "A1,B2,C3,D4,E5,F6"
- On Error Resume Next
- For i = 0 To UBound(Split(strFind, ","))
- Err.Clear
- Set rngTemp = Rows(3).Find(what:=Split(strFind, ",")(i), LookAt:=xlPart).MergeArea
- If Err.Number = 0 Then
- Debug.Print Split(strFind, ",")(i) & "由" & rngTemp(1).Column & "-" & rngTemp(rngTemp.Count).Column & "组成"
- End If
- Next
- End Sub
复制代码 |
|