sub to Delete Rows meeting specific requirements

Hi
I do have a working function with deletes rows where in a specific column is either 13 or "" (Nothing) .

Please Login or Register  to view this content.

The bad thing in here is, that the 13 is hardcoded. I sometimes need in the code the 13, sometimes the 13 and 15.
My solution now is having two subs one deleteRow13 and one deleteRow15.

What I want is a sub that I can call with optional parameters
e.g.

Please Login or Register  to view this content.

Did I make myself clear?
Thanks for reading.
Fabian

P.S.
While typing there formed another question:
does it matter if I use for i = ... or for each cell in range

Do you mean like this:

Please Login or Register  to view this content.

AWSOME Fast response,
thank you.
Something like that, but sometimes

• I need 13
• I need 15
• i need 15 AND! 13

for the first to cases your code works, but not for the third. Though I could do
call deleteRow13(...,13)
call deleteRow13(...,15)
But what I wanted is one procedurecall with two of them
call deleteRow13(...,13, 15)

Oh, I see:

Please Login or Register  to view this content.

hi FabianWinter, option, select range and run the code:

Please Login or Register  to view this content.

Thank you guys, all solutions are helpful.

@Norie EXACTLY what I needed Thank you very much.