VBA to delete Row if cell value in Column matches value in "A1"

[Spoonman667]

Hi Guys,

Don't know if the is possible but I want a macro to delete the entire row if any cell in column B matches the cell value in "A1"(which is a formula controlled dynamic cell).

I know I can do it to a set criteria but can't work out how to do it with cell value.

Any Ideas?

Thanks,


Spoonman.

[Richard Buttrey]

Hi,

Here's one way

Please Login or Register  to view this content.

[Spoonman667]

Thanks Richard,

Short but sweet, love it.

[Richard Buttrey]

Thanks,

Slightly more economical

Please Login or Register  to view this content.