- ©«¤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
|
¦^´_ 5# yen956
§Ú±Nã´£³¡ªLª©¤jªº¦Ûq¨ç¼Æµyµyקï¤F¤@¨Ç¡A
§A¥Î [F8] ¥h Debug ¤@¦¸¡A«K·|¥þ½L©úÁA¤F¡C
§Ú±Nµ²ªG§ï¼g¨ì K Äæ¡A¥H«K§A¶i¦æ¤ñ¹ï¼g¤JÈ¡C- ' ¦Ûq¨ç¼Æ¡A¼u©Ê¸û¦n¨Ç¡G By ã´£³¡ªL
- ' ¢Ø¢³¡D¤½¦¡¡G=get_wl(B$3:E$11,H4,I4)
- Function GET_WL(xA As Variant, Va As Range, Vb As Range) As String
- Dim Arr, AA, j&, Jm%, T$
-
- Arr = xA
- For j = 1 To UBound(Arr)
- If Arr(j, 2) <> "" Then
- Jm = 0: AA = Split(Arr(j, 2) & "~", "~")
- If Va > Val(AA(0)) And Va <= Val(AA(1)) Then T = Arr(j, 1): Jm = 1
- End If
- If Jm = 1 Then
- AA = Split(Arr(j, 4) & "~", "~")
- If Vb > Val(AA(0)) And Vb <= Val(AA(1)) Then GET_WL = T & "_" & Arr(j, 3): Exit For
- End If
- Next j
- End Function
- Sub Ex()
- Dim cts As Integer
-
- For cts = 0 To 5
- [K4].Offset(cts) = GET_WL(Range("B$3:E$11"), [H4].Offset(cts), [I4].Offset(cts))
- Next cts
- End Sub
½Æ»s¥N½X |
|