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.
Last edited by lealea1982; 02-24-2015 at 12:34 PM.
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)Please Login or Register to view this content.
Does this work any better?
Please Login or Register to view this content.
If posting code please use code tags, see here.
Yes perfect, thank ou both!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks