Je peux facilement build une plage dans laquelle la même cellule apparaît deux fois (dans ce cas, cellule B1):
Sub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B2") Set r3 = Union(r1, r2) MsgBox r3.Count End Sub
Comment puis-je build une plage dans laquelle la même cellule apparaît plus de deux fois?
Je ne sais pas si je suis à l'intérieur de votre tête ou pas avec cela, mais cela semble countr et inclure la cellule B1 trois fois et agir comme une gamme explicite.
Sub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub
Sub IAmTheCount ()Sub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub
Dim r1 As Range, r2 As Range, r3 As Range, r4 As RangeSub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub
Définir r1 = Plage ("A1: B1")Sub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub
Régler r2 = Plage ("B1: B5")Sub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub
Définir r3 = Plage ("B1: C2")Sub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub
Définir r4 = Union (r1, r2, r3)Sub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub
MsgBox r4.Count & "-" & r4.AddressSub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub
r4.Interior.ColorIndex = 4Sub IAmTheCount() Dim r1 As Range, r2 As Range, r3 As Range, r4 As Range Set r1 = Range("A1:B1") Set r2 = Range("B1:B5") Set r3 = Range("B1:C2") Set r4 = Union(r1, r2, r3) MsgBox r4.Count & " - " & r4.Address r4.Interior.ColorIndex = 4 End Sub