- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 7# happycoccolin
¬O§_¦p¦¹¡H
- Function zz(rng As Range, Page As Range, FVal) As String
- Dim SN(), flag As Boolean
-
- For i = 1 To rng.Count ' rng.Count = 14
- If rng(i) = FVal Then ' rng(1) = "1234-5678"¡B
- If s > 0 Then
- flag = True
- For j = 0 To s - 1
- If (SN(j) = Page(i)) Then
- flag = False
- Exit For
- End If
- Next j
- Else
- flag = True
- End If
-
- If flag Then
- ReDim Preserve SN(s)
- SN(s) = Page(i): s = s + 1 ' Page(1) = "aa"
- End If
- End If
- Next
- zz = Join(SN, "¡B")
- End Function
- Sub Test()
- With Sheets(2)
- str1 = zz(.Range("A1:A14"), .Range("B1:B14"), "1234-5678")
- End With
- MsgBox str1
- End Sub
½Æ»s¥N½X
123-0507.rar (15.94 KB)
|
|