Greetings,
I am not able to figure out what I am doing wrong. I need to determine if the last 3 letters for cell AI4 = "AUV". However my code is not recognizing this.
Sub conAUV_pHs1()
Dim ws As Worksheet
Dim b4Var As Variant
Dim ai4Var As String
Set ws = ActiveWorkbook.ActiveSheet
b4Var = "Rest #"
ai4Var = "AUV" 'This cell's last 3 letters will always be AUV.
If ws.Range("B4").Value <> b4Var Or ws.Range(Right("AI4", 3)).Value <> ai4Var Then
uf_Message_conAUV_phase.StartUpPosition = 2
uf_Message_conAUV_phase.Show
ActiveWorkbook.Close False
End
Else
End If
End Sub
Bookmarks