for each problem with two conditions

[peterschein]

Dear Users,

can anyone please help me why my code doesnt work?

(please also find the file attached)

Please Login or Register  to view this content.

thank you indeed for your kind help!

br
Peter

[Pepe Le Mokko]

Please explain what "doesn't work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

[jindon]

Please Login or Register  to view this content.

[peterschein]

...thank you jindon... what a silly mistake

one more question please.. my initial goal was to delete the row where the two conditions are met.. I wrote it like below but doesnt work..do you know why?

Please Login or Register  to view this content.

[jindon]

When you delete/add row(s)/column(s), better loop backwards like

Please Login or Register  to view this content.

For each deletes one row when consecutive rows/columns are to be deleted.
Another would be Union method and delete all at the end, AutoFilter etc...

[peterschein]

very cool! thank you again jindon!

[peterschein]

Please explain what "doesn't work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

sorry about that Pepe Le Mokko!
I will be more specific in the future

[Jean.P28]

Try this

Please Login or Register  to view this content.

[peterschein]

Try this

Please Login or Register  to view this content.

makes sence too! thank you for your help and time!

[jindon]

peterschein,

You should be careful that your code is based on the named range, so if the range in the named range changes, yours and mine don't need to change, but the other one should.

[peterschein]

peterschein,

You should be careful that your code is based on the named range, so if the range in the named range changes, yours and mine don't need to change, but the other one should.

I am sorry but I am not sure what you mean. the range will change but since its a table it should not be a problem... what do you mean by "the other one should"?

[Pepe Le Mokko]

Please don't quote entire posts unnecessarily. They are just clutter and make threads hard to read.
Use the "Quick reply" instead
Thanks

[jindon]

If your named range refers to, say C10:D100, my code doesn't need to be changed.

That's what I'm saying.