Delete row macro based on cell value always deletes the first row

Asked May 22 '20 at 16:01

Active May 23 '20 at 03:36

Viewed 90 times

I have a VBA macro set up to delete a row based on a value provided in a cell. So I wrote something that is supposed to filter the second column to find the desired value and delete the row. My problem is that for some reason it always deletes the first row no matter what, even if the value is not present in the sheet.

M2 is the cell with the value I want found in the table. The UnMerge part is because it merged some cell and my sort macro wasn't working with merged cells.

Here is the code:

Private Sub DeleteCarte_Click()
Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets("INDEX")
With ws.Range("A6.F600")
    .AutoFilter Field:=2, Criteria1:=Range("M2").Value
    .EntireRow.Delete
End With
Sheets("INDEX").Range("A1:F600").UnMerge
End Sub

edited May 23 '20 at 03:36

BSMP

4,596
8
33
44

asked May 22 '20 at 16:01

JMV

`Criteria1:=ws.Range("M2").Value` – Siddharth Rout May 22 '20 at 16:09
1

Also to delete use `.Offset` as shown [HERE](https://stackoverflow.com/questions/11317172/delete-row-based-on-partial-text/11317372#11317372) – Siddharth Rout May 22 '20 at 16:15
1

`"A6.F600"` is not a valid range reference, that `.` looks like a typo – BigBen May 22 '20 at 17:05

Delete row macro based on cell value always deletes the first row

0 Answers0