Hi All

I have found various similar threads on here however none of the solutions actually work for me, or rather I cannot make them work for me, that is.

Basically I have a sheet with a quotation table in it. In column C is a drop down list which automatically populates the model no. and price columns as per a VLOOKUP, which works great.

There are 14 lines on the quote table, as there are 14 possible products. Once a quote has been completed I would like to delete the rows which have not had a selection made from the drop down validation box. I only want the code to run in the range C57:C70.

As an addition there are pages of text after the page which this quote table is on, and for every line which is removed I would like a line added a the bottom of the page, row 79, in order to keep these pages in alignment for printing.

I have tried various peices of code and played around with them and the nearest I have managed to get is as follows:

Private Sub delete_empty_rows()
       
         
        Dim i As Long
For i = Range("C70").End(xlUp).Row To 57 Step -1
    If IsEmpty(Cells(i, 4)) Then Rows(i).Delete
Next i
          
End Sub
However this deletes the rows within the range which DO have something in column C rather than empty cells and I cannot work out why.

Please help!

Many thanks

Ben