Av8tordude
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 1,074
- Office Version
- 2019
- Platform
- Windows
I would like to exclude the words "Call" or "Put" when running this code. How can I modify this code to achieve this?
VBA Code:
For Each rCell In Wks.Range("C7:C" & X)
If Not Dic.exists(Split(rCell.Value, "-")(1)) Then
Dic.Add Split(rCell.Value, "-")(1), Nothing
End If
Next rCell
cbT3.List = Dic.keys