Macro (Delete Entire row Cell in column R is empty)

You could do a For Loop. You could write it so it says:

for each cell in range ("") 
If cell.value = "" Then 
cell.entirerow.delete
End If
next cell

Code doesn't work. I'm new to VB so please help

Conditional formatting makes it yellow. No other reason

Sorry that was example Try

Dim cell as Range

For each cell in range ("R:R")
If cell.value = "R £0.00" Then 'if you want this to look for cell which have no values at all put if cell.value = ""
cell.entirerow.delete
End If
Nex Cell

Hi Jeskit

It worked but I have to run it a couple of times before it completely remove all lines

I have it as follows

Sub Delete_Row()

Dim cell As Range

For Each cell In Range("Quotation!R21:Quotation!R105")
If cell.Value = " " Then 'if you want this to look for cell which have no values at all put if cell.value = ""
cell.EntireRow.Delete
End If
Next cell

End Sub