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.
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.
TryPlease Login or Register to view this content.
Maybe:
You should loop from bottom to top when inserting rows.Please Login or Register to view this content.
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
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....Please Login or Register to view this content.
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.
Yes, #
You are right,
My bad...
I had in my code a code to sort data
so my macro did add the row but then sorting removed empty rows:DDPlease Login or Register to view this content.
many thanks
Glad you got it worked out and thanks for the feedback and the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks