VBA delete row above if

[Sparda142]

Hello,


Im not great at vba so im looking for some help. Im looking say if in column A, Delete the row above if date value in A1 does not match the date value in A2

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR]
[TD="class: xl66, width: 105, align: right"]8/1/2019 9:16[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR]
[TD="class: xl66, width: 105, align: right"]7/22/2019 21:04[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR]
[TD="class: xl66, width: 105, align: right"]7/22/2019 20:55[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR]
[TD="class: xl66, width: 105, align: right"]7/22/2019 20:55[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR]
[TD="class: xl66, width: 105, align: right"]8/1/2019 9:16[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][TABLE="width: 111"]
<tbody>[TR]
[TD="class: xl66, width: 111, align: right"]8/1/2019 14:02[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[My Aswer Is This]

So in this example we would delete what rows?

 

[Sparda142]

yes

 

[Rick Rothstein]

yes

"yes" is nowhere near the correct answer to what "My Aswer Is This" asked you.

What he (and me) want to know is this... you gave and example of you data, now tell us what rows are to be deleted.

 

[Sparda142]

My apologies, I was switching between screens when i wrote "yes"

Basically what i'm trying to say is if the cell a1 date value is not the date value of the cells below delete the row. However if the cell is blank within the column do nothing

 

[Rick Rothstein]

Basically what i'm trying to say is if the cell a1 date value is not the date value of the cells below delete the row. However if the cell is blank within the column do nothing

So Rows 2, 3 and 4 should be deleted?

 

[Sparda142]

yes , 2,3 and 4 should be deleted.

 

[My Aswer Is This]

You still did not answer my question.

My apologies, I was switching between screens when i wrote "yes"

Basically what i'm trying to say is if the cell a1 date value is not the date value of the cells below delete the row. However if the cell is blank within the column do nothing

 

[My Aswer Is This]

I will see Ricks answer to this. Considering skipping blank rows I have no answer.

 

[Sparda142]

any luck?