Loop won't stop looping

I have data on an Import tab. I have a macro built to loop through the names on a build tab and copy information from the import tab. When I step through the macro I get all the necessary information but the loop won't stop.

Please Login or Register  to view this content.

Any help is appreciated.

Additional information: The loop is matching names from each worksheet.

hi ciresuark,

Without looking at the workbook, it is hard to say exactly what is up. One question that comes to mind right away is this: What is the value of lrow before the loop starts? Have you stepped through the code until say "ws.activate" and then checked the value of lrow? If for some reason that value is 1, then x will never equal lrow since x starts at 2, and the loop would run indefinitely (or until it errors out because the row reference becomes invalid EVENTUALLY)

There must be something in that row... check ws3 ("Build"), and see if A1019 has a space or something?

What's the value of the lrow variable?

If the Build worksheet column A is empty before you start then presumably it will be the value 1 and since you're starting x at 2 x will never = 1.

Difficult to comment without seeing the actual workbook.

Glad it was sorted

Thanks for the rep, and marking the thread as solved!