Thread: delete row if value in column matches cell

I need help writing a macro that search through column B for a valute that is located under another workbook, namely here:
Workbooks("Copy of Kopia med makro").Sheets("Projkektuppföljning").Range("B46").

If anything matches this cell value, I want to delete the entire row.

Thanks in advance !

Try this code...

   For i = Cells(Rows.Count, "B").End(xlUp).Row To 1 Step -1
      If Cells(i, "B").Value = Sheets("Projkektuppföljning").Range("B46").Value Then
         Cells(i, "B").EntireRow.Delete
      End If
   Next i