I've started learning VBA from scratch this week, but I've been given a task at my internship that's stumping me. I'm trying to match information in two different worksheets in a common column, compare the two rows, highlight cells with differences, and then copy any rows that have differences to a different worksheet. Here is the part of the code that I believe is creating an infinite loop:
I'm just taking an initial stab at this, but I'd like to know why the loop is infinite and how I might be able to fix it.Please Login or Register to view this content.
I am also aware that, if there are multiple differences in a single row this could create more problems. Let's assume for now that each row only has 0 or 1 differences.
Thanks
Bookmarks