1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| Public Sub ESSAI()
MsgBox Découpe("R16C3:R35C18", 1)
MsgBox Découpe("R16C3:R35C18", 2)
MsgBox Découpe("R16C3:R35C18", 3)
MsgBox Découpe("R16C3:R35C18", 4)
End Sub
Public Function Découpe(ch As String, valeur As Byte)
Dim tb1, rg1, rg2, tb11, tb12
Dim v1 As Integer
Dim v2 As Integer
Dim v3 As Integer
Dim v4 As Integer
tb1 = Split(ch, ":")
rg1 = tb1(LBound(tb1))
rg2 = tb1(UBound(tb1))
tb11 = Split(Replace(rg1, "R", ""), "C")
v1 = tb11(LBound(tb11))
v2 = tb11(UBound(tb11))
tb12 = Split(Replace(rg2, "R", ""), "C")
v3 = tb12(LBound(tb12))
v4 = tb12(UBound(tb12))
Select Case valeur
Case 1
Découpe = v1
Case 2
Découpe = v2
Case 3
Découpe = v3
Case 4
Découpe = v4
End Select
End Function |
Partager