I am trying to create a macro that will automatically insert 2 rows in the two rows adjacent to each other do not equal. It works perfectly for about the first 1000 rows and then all of a sudden it stops working. I don't know if there is some other issue at work here but wanted to see if anyone had any ideas.
End Sub
Please Login or Register to view this content.
You have to also increment the "position" variable when you insert the rows. Maybe we can help you make your code better if you provide a sample sheet that you are using with the above code.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I would but I am not able to provide that information as it is company info. Basically it is a column full of company locations. Hope that helos.
You do not need to upload your original file. Just a sample file with dummy data will do, so we understand the layout.
Notice the issue when the script is ran between city 4 and city 5.
I figured it out. Thanks for trying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks