Delete Cells

Hello

I would like to create a VBA that can delete all rows with criterias that apply to cells in Column C

from C1 to cell with TExt : "Brussels"

and then from Cell with text :"Debit Count" till cell with text : "Paris"

can anyone help please ?

Thanks

Hi Robert

thanks for the reply,

unfortunately executing the macros make no changes to the excel sheet, I have attached the Data. hopefully this clarify what is happeing,

Thanks again for the help.

Bimo

Hi Robert

Actually I would like to Delete all rows from 1 to 141 and then from 175 to 425 and then from 453 till end of Data

Thanks

Bimo

Hi Robert

It works, the only issues is row changes when the report is updated. So is it possible to instruct the delete of rows based on the content of Cells as per follow ?

Delete All Rows from cell 1 on Colum C to Cell above Cell with text “Belgium”

Delete All Rows from cell, the one above Cell with Text “Stockholm” on column C to Cell above Cell with text “Paris”

Delete All Rows from cell, the one above Cell with Text “Vienna” on column C till end of Data, usually not beyond Row 1500


Sorry for the miscommunication, I should have been clearer from the start

Bimo,