Insert Entire Row wont stop

[nosense]

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.

[Joe Bushfield]

Try

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

You should loop from bottom to top when inserting rows.

[nosense]

Try

Please Login or Register  to view this content.

did not change anything

[nosense]

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)

[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.

[nosense]

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....

[JOHN H. DAVIS]

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

[nosense]

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

[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.

[nosense]

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

[JOHN H. DAVIS]

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