E' così?
- Codice: Seleziona tutto
Sub EliminaRighe2()
UR = Range("D" & Rows.Count).End(xlUp).Row
For RR1 = UR To 2 Step -1
If UCase(Range("D" & RR1).Value) = "# MESSAGE: CROSS.JPG" Then
RigaU = RR1 - 1
For RR2 = RR1 - 1 To 1 Step -1
If Mid(UCase(Range("D" & RR2).Value), 1, 18) = "# MESSAGE: SUBJECT" Then
Rows(RR2 + 1 & ":" & RigaU).Delete
RR1 = RR2
GoTo saltaRR1
End If
Next RR2
End If
saltaRR1:
Next RR1
End Sub