I have a cells that have a combination of letters like "EGM". I have been trying to make and If/Then that if the cell contains an "E", then I will ask it to copy and paste some cells. So far all I have is:
If Sheet1.Range("b12:b12") = "=E" Then
GoTo line1
Else GoTo line2
line1:
Sheet1.Range("S16: S16 ").Copy
Sheet1.Range("T16:T16").PasteSpecial
line2:
End If
End sub
If I change the ="=E" to ="EGM", then it works but it has to match all the letters. I want to be able to pick out each letter seperately.
If Sheet1.Range("b12:b12") = "=E" Then
GoTo line1
Else GoTo line2
line1:
Sheet1.Range("S16: S16 ").Copy
Sheet1.Range("T16:T16").PasteSpecial
line2:
End If
End sub
If I change the ="=E" to ="EGM", then it works but it has to match all the letters. I want to be able to pick out each letter seperately.