Insert Entire Row wont stop

I have a code that suppose to insert entire row if 'IF' statement is fulfiled but it does insert multiple rows and wont stop until i stop running macro manualy.

Here is part of my code:

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

You should loop from bottom to top when inserting rows.

Originally Posted by Joe Bushfield

Try

Please Login or Register  to view this content.

did not change anything

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

You should loop from bottom to top when inserting rows.

I tried this and nothig happens (no row inserted)

Are both conditions being met? Can you attach a sample where it doesn't work?

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Are both conditions being met? Can you attach a sample where it doesn't work?

Please Login or Register  to view this content.

Both conditions are being met .
When i do

Please Login or Register  to view this content.

it does work i.e. does place entire row below cell of interest but it carries on forever instead of stopping after inserting one row....

Can you attach a sample where it doesn't work. You should loop from bottom to top when inserting rows.

Originally Posted by JOHN H. DAVIS

Can you attach a sample where it doesn't work. You should loop from bottom to top when inserting rows.

ok
here is a samplesample.xlsm

This works for me on the sample you provided when the conditions are met.

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

This works for me on the sample you provided when the conditions are met.

Please Login or Register  to view this content.

Yes, #
You are right,
My bad...
I had in my code a code to sort data

Please Login or Register  to view this content.

so my macro did add the row but then sorting removed empty rows:DD

many thanks

Glad you got it worked out and thanks for the feedback and the rep.