Deleting a Row

[yuenk]

I want to delete a row based on two values in that row.

If column C has a value of Black and column F has a value of Billing Qty I want that row to be deleted.



Thanks for any help!

[6StringJazzer]

Please Login or Register  to view this content.

[yuenk]

Please Login or Register  to view this content.

I get Runtime error 1004 on If Cells(R, "C") = "Black" And Cells(R, "F") = "Billing Qty" Then

[Arkadi]

6StringJazzer put in comment to "Set R to row of interest"... so you need to assign a value to R before the If statement

[6StringJazzer]

Also, this code is intended to be located in the sheet you are working on. If you put it in a generic module, it will default to ActiveSheet.

I have a feeling there is a lot of detail you haven't told us, so obviously I couldn't give you a detailed, ready-to-wear answer. For example, do you need to do this in a loop?

[jolivanes]

@6StringJazzer
What happened to your crystal ball?

[6StringJazzer]

@6StringJazzer
What happened to your crystal ball?

Some days the crystal is cloudy.....