Unable to delete certain rows

Hallo helpers

I'm unable to find a solution using VBA.
I need to delete entire rows where a cell in that row has a certain value.

AAA BBB CCC
1 2 3
11 22 33
111 2 333
111 222 333

I need to remove the rows that have value 2 in column BBB (In this case row 1 and 4)
I need the result to be:

AAA BBB CCC
11 22 33
111 222 333

Hope for your help
Thank you

When running the code, a input box will appear in which you'll need to enter the column you like to choose.
The code below will delete the rows containing number 2 in the column that you'll choose.

Please Login or Register  to view this content.