VBA to delete an entire row when a column matches a value

[Mr_bikahs]

Hello all,

Was wondering whether anyone could help me. Essentially I am trying to get something working that would look at column L in my spreadsheet, and if the value in a row for that column is equal to "Delete", it will delete the entire row in the spreadsheet.

Is there a formula I can use for this or will it require VBA?

Many thanks in advance

 

[Marcelo Branco]

Hi,

Maybe this can help

http://www.rondebruin.nl/delete.htm

M.

 

[Mr_bikahs]

Hello Marcelo,

Thanks for this. Been having a look at this. What I need though is that when a row is deleted, every row below needs to be moved up a row. I.e there should be no empty rows.

Don't think there is anything in those examples where the rows are moved up after a deletion. Is there a piece of code I can insert to do this?

Many thanks

 

[Marcelo Branco]

Hello Marcelo,

Thanks for this. Been having a look at this. What I need though is that when a row is deleted, every row below needs to be moved up a row. I.e there should be no empty rows.

Don't think there is anything in those examples where the rows are moved up after a deletion. Is there a piece of code I can insert to do this?

Many thanks

Hi,

Try one the codes in the Ron de Bruin's page and you'll see that everything works fine - no empty rows in the middle of your data are left.

Try it on a test-workbook

M.