Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- For i = .Rows.Count To 1 Step -1
- If .Item(i) = "w" Or "x" Or "y" Or "z" Then
- .Item(i) = "A"
- End If
- Next i
- If .Item(i) = "w" Or .Item(i) = "x" Or .Item(i) = "y" Or .Item(i) = "z" Then
- For i = .Rows.Count To 1 Step -1
- Select Case .Item(i)
- Case "w", "x", "y", "z"
- .Item(i) = "A"
- Case "something else"
- 'If you have other criteria
- Case Else
- 'If you have a action item for something that isn't any of the above
- End Select
- Next i
- Dim arr() As String: arr = Split("w,x,y,z", ",")
- For i = .Rows.Count To 1 Step -1
- For j = LBound(arr) To UBound(arr)
- If .Item(i) = arr(j) Then .Item(i) = "A"
- Next j
- Next i
Add Comment
Please, Sign In to add comment