Code: Select all
If Mid(TEST, 12, 19) = "OPERAZIONE ESEGUITA" And new condition Then
how to?
note:
the series of avlue are in a column A of sheet1
similar:
aa
cc
vv
ff
gg
...
tt
Code: Select all
If Mid(TEST, 12, 19) = "OPERAZIONE ESEGUITA" And new condition Then
InsteadHansV wrote:Please explain what you mean by "i want to set a series of values".
Code: Select all
If Mid(TEST, 12, 19) = "OPERAZIONE ESEGUITA" Then
Select Case cod
Case "aa", "cc", "vv", "ff", "gg", ..., "tt"
' code here for when cod is one of the above values
Case Else
' code here for when cod is NOT one of the above values
End Select
End If
TKS!HansV wrote:You could do it like this:
Code: Select all
If Mid(TEST, 12, 19) = "OPERAZIONE ESEGUITA" Then Select Case cod Case "aa", "cc", "vv", "ff", "gg", ..., "tt" ' code here for when cod is one of the above values Case Else ' code here for when cod is NOT one of the above values End Select End If