lizsunnysideup
New Member
- Joined
- Jun 29, 2019
- Messages
- 36
Hello!
I'm currently having an issue with my code and below is the part I'm having trouble with:
Dim AA As Long
For AA = 1 To Cells(Rows.Count, "AF").End(xlUp).Row
If Range("AK" & AA).Value = "”USE SCC 02 FOR INITIAL DOSE, SCC 06 FOR" And Range("AK" & AA).Value = "NON 0 VALUE REQUIRED FORVACCINE ADMIN" And Range("A" & AA).Value = "" Then
Range("A" & AA).Value = "COVID BILLING ERROR"
End If
Next AA
End Sub
I'm trying to flag as COVID billing errors, but the text in column AK is exactly "USE SCC 02 FOR INITIAL DOSE, SCC 06 FOR
VBA won't let me use double quotation marks and I'm stuck as to how to fix this.
I'm currently having an issue with my code and below is the part I'm having trouble with:
Dim AA As Long
For AA = 1 To Cells(Rows.Count, "AF").End(xlUp).Row
If Range("AK" & AA).Value = "”USE SCC 02 FOR INITIAL DOSE, SCC 06 FOR" And Range("AK" & AA).Value = "NON 0 VALUE REQUIRED FORVACCINE ADMIN" And Range("A" & AA).Value = "" Then
Range("A" & AA).Value = "COVID BILLING ERROR"
End If
Next AA
End Sub
I'm trying to flag as COVID billing errors, but the text in column AK is exactly "USE SCC 02 FOR INITIAL DOSE, SCC 06 FOR
VBA won't let me use double quotation marks and I'm stuck as to how to fix this.