Kód: Vybrat vše
Private Sub UserForm_Initialize()
Dim aa22 As Worksheet
Dim aa22aa, aa22bb, aa22cc,a2 As Range
Set aa22 = Worksheets("odběratelé")
Set aa22aa = aa22.Range("j2:j2000")
For Each a2 In aa22aa
If a2.value = "OK" Then
On Error GoTo prvni
Set aa22bb = Union(aa22bb, a2)
GoTo dalsi
prvni:
Set aa22bb = a2
dalsi:
End If
Next a2
aa22cc = aa22bb.Offset(0, -8)
vyber.RowSource = aa22cc
End Sub
nevíte jak na to?