Loop not working properly - code included - help?

[lealea1982]

Hello,
I have the following but of VBA code as a loop. For each loop (from rows 2 to 50) I want it to check whether the value in column U is 0 and if it is to just move straight to the next row/loop... if the data is not 0 I want it to run the rest of the code. However, it runs through 2 loops (the first has 0 in column U, the second doesn't) and then just stops... so I think I have something the wrong way round?

Please Login or Register  to view this content.

[stnkynts]

Please Login or Register  to view this content.

The way this is written, it is a variable range reference depending on the active workbook and active sheet. Since you are changing the active workbook I would guess it is failing there. Try specifing the workbook/worksheet for the range reference (i.e. Workbook.Worksheet.Range)

[Norie]

Does this work any better?

Please Login or Register  to view this content.

[lealea1982]

Yes perfect, thank ou both!