How to delete rows if set parameter is satisfied

**Adam1987** · 08-09-2012, 12:21 PM

I am working in a workbook, where i want to be able to delete certain rows of data, depending on a variable cell.
For example, in the attached excel file, im trying to write a macro to delete all rows in the table which do not have the 'cardcode' outlined in A1.

I have managed to hide all cell, but cannot seem to delete.

It goes without saying, that any help will be greatly appreciated!

Thanks.Book1.xlsx

**oeldere** · 08-09-2012, 12:29 PM

Maybe, you can also show is the used code for hide all cells.

**Adam1987** · 08-09-2012, 12:34 PM

Here is the current macro to hide cells;

Please Login or Register  to view this content.

Thanks in advance,
A

**mmmarks** · 08-09-2012, 12:36 PM

hi try this,

Please Login or Register  to view this content.

**Cutter** · 08-09-2012, 03:38 PM

@ Adam1987

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**oeldere** · 08-10-2012, 10:16 AM

@mmmarks

I tested youre code and i think it only deletes the first 3 rows.

Maybe I did it wrong, but I get no failure messages.

Wil anyone explain to me if i'm wrong?